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 ...
There are multiple way I could imagine to get what you want but having an actual sample sheet would significantly help us cater a formula for what you want. That said if you want to give it a try here are some thing I would consider:
a) filter by unique product and station then check max time stamp then filter again by only product 'coming' to that station
b) use countifs to determine which products have an ODD number (unless it is the 1st station which you would be looking for an EVEN number unless you have an line indicating the arrival of the product at station 1 also) of entries. Or if you other entries then use countifs arrival > countifs departure.
