Forum Discussion
Column skipping
I have 100 toys, and I would like to get the total profit for each color of toy, and the average profit. 1 column for each toy, 100 columns. In between each toy column will be random various text, in...
https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-search-for-multiple-records-for-the-same/15e19823-ca02-40dd-9736-e8234fc8bc3e
Try transfer to one dimension list first before calculation.
Try transfer to one dimension list first before calculation.