User Profile
aludka
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Fresh insight to an excel problem
PReagan The "CP" I was referring to is the location. Each of these entries in this workbook logs a move from the "previous location" to the "current Location." What I'm looking to do is query a specific "current location" and find all the product that is in there. For example, say I have lots "abc1" through "abc50." Each of these lots may have multiple entries in the table. Going from location 1 to 5, back to 1, then to 3. What I'm looking to do is for every unique "current location" find all the lots which have the most recent "current location" entry of that location. I'm not sure if that makes sense or not.2.1KViews0likes1Comment- 2.1KViews0likes0Comments
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 control points. Let's say I have 5 control points (CP1-CP5.) This product, though it's manufacturing life cycle, will transition to and from some of these control points. Every time a person moves a piece of product from one CP to another CP they create a report listing the date, where it's moving from and where it's moving to. I keep a summary of all these reports in a table. If I want to find the current location of, for example, piece X1, I simply find the most recent entry in the table for X1. What I'm trying to figure out is how to look at a certain CP and find out everything that's still in there. When I do that now, I have a lot of entries, but some of these pieces of product will have moved on. Example sheet added. Any idea would be appreciated.2.4KViews0likes18Comments- 2.1KViews0likes0Comments
- 2.2KViews0likes0Comments
Recent Blog Articles
No content to show