I have attached a sample sheet with Raw data on it, as well as How I want to have the data resorted. Basically, tracking a customer through a sales cycle, and I want to be able to see if they hit certain stages (the sort column)
So I am trying to figure out how to generate a listing of a customer number, customer name, and then an "x" (or whatever) in the appropriate box so that i know they have hit that state.
A company may appear more than once in the same stage... (for example Company A has Sort A twice..... if that happens, only one mark is needed in Column M, and that company needs to appear only once).
A company may not hit all of the stages in order as well.
The sample sheet has raw data in columns A through D
Columns K through Q, is how I would want it to look.
Any help/thoughts are greatly appreciated
**** Update ****
Column B will contain a date that the last customer hit a certain stage. If there is a way to pull only the most recent date that the customer hit that part of the cycle, that would be awesome... if not, it is not a big deal.
Bookmarks