Forum Discussion
Converting pasted data to customer follow-up information
StephenGundrum , The original version assumed that there will be only one occurrence of Rep, so it was erroring out when a rep was there twice. I changed the logic to accommodate multiple occurrences of Reps. See if this works.
StephenGundrum , looks like a perfect use case for Power Query. Paste more information in the Paste Tab and extend the formulas in the table on the right side. Update the Rep list as well. Then click on Data->Refresh All to update the Act and Up table. Let me know if you run into any issues...
TheAntony [Expression.Error] There were too many elements in the enumeration to complete the operation.
Is this error after pasting in the new data? Also, in your iferror formulas, you have used a " " as the 2nd argument. Make sure it remains " ". You will get an error if you change it.
- Yes. I pasted more data on the left side of the Paste sheet. I then dragged down the formulas on the right side of the Paste sheet. That part worked. When I went to Data>Refresh All is when that error message popped up.
StephenGundrum , can you attach the updated file?