Forum Discussion
Fresh insight to an excel problem
I wonder if you're going to get a flurry of possible answers. I'm attaching one that makes primary use of the FILTER function, only available in the newest versions of Excel.
There's a cell with yellow background where you can select the code for one of your "current locations" --when you do that, the date below will automatically populate with the latest date for which there's an entry for that location.
Then the list will automatically populate with the rows that correspond to that location and date.
as others have noted, you may need to refine your table to be more specific on actual products...or maybe we're just not seeing what's there in front of us.
Our methods (pregan's pivot table, my use of FILTER) may suffice to give you that "fresh insight" you were seeking, in any event.