Hello,
I am working in a larger data set, and am having a hard time with ID numbers which can show up more than once. The database captures the amount of leads generated and tracks them through different status points. An ID number for a given lead can show up multiple times depending on how many meetings are associated with that lead.
In the attached:
Problems:
1) How would I be able to calculate the total number of raw leads generated when a lead can sit in "raw" status for more than one meeting? I am looking to count the first instance "raw" shows up in column D for each lead in column B
2) How can I capture the most recent number of leads under each status point? This involves counting the value in column D after finding the maximum value of a given ID (column B) in column C
Bonus: Is there a formula I can drag down in column C that would show the next meeting number for each ID (I think it is just a count of the number of times the instance has shown up in column B)
Bookmarks