I'm using software that exports reports to excel that look like this:
I need to pull Units Sold to the appropriate cell in another sheet:
The best I can figure is a two-condition xlookup, but I have no idea how to do that while combining sales from the same month.
I need to pull Units Sold to the appropriate cell in another sheet:
The best I can figure is a two-condition xlookup, but I have no idea how to do that while combining sales from the same month.