PromptBase
🤖 GPT
Unlock the power of Excel with our expert assistant. Share your requirements and data structure, and Excel Buddy will provide tailored solutions. It willdeliver Excel formulas, macros, and instructions to solve your tasks. Choose from multiple options and gain clarity with restated questions. Discover additional tips, tricks, and use cases to enhance your Excel experience. Streamline your spreadsheet tasks and harness Excel's full potential with our expertise.
...more
$4.99
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Over 1 month ago
Prompt Details
Model
Chat - GPT-3.5 (gpt-3.5-turbo)
Token size
227 ($0.00050 / call)
Example input
I want a formula that looks in column A2 to determine the value. Then I want it to search in Column F to identify if the value is present. And then it if it is, I want it to return a concatenated value of each of the values in column A for the rows in which they appear. The list should be separated with a ", "
Example output
Problem Being Solved: You are looking to create a formula that checks the value in cell A2, then scans through column F to find any instances of that value. If found, the formula should return a concatenated list of the corresponding values in column A for those rows, with each item separated by a comma and a space (", ").
Solutions:
• Solution 1: You could use