Forum Discussion
Fresh insight to an excel problem
I hoping to get some fresh thoughts on a problem I'm trying to solve in excel. I work in a manufacturing plant and my job is to track the location of certain product as they move through various ...
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.