Hello everyone, hope all is well. I will be making a presentation – automated gathering of info. I just can’t figure out how to make this happen.
The first spreadsheet would be the output, the date on the top are the ship dates. I have customers that are ordering 2 items irregularly, need to track their orders.
Output.JPG
2nd image is where to get the output:
Raw Data.JPG
Is there a simple formula for this? Any help would be greatly appreciated. Thanks in advance!
Bookmarks