Forum Discussion
Sum operation under many conditions
Hi I need to do sum operation based on following conditions: 1.Each name in table 2 should be compared with names in table 1, if it is compatible or equal then moves to the second conditions. 2. c...
Thanks for your reply
I can unmerge the cells and rearrange table 1 as shown in the attached file.
Thank you. The workbook I attached above did the same.
The key step is to first flatten the data:
Pull out the necessary columns and then PIVOTBY can make short work of things.
- Does it work on Google sheet?
- I can't speak for compatability. I don't use Google sheets.