MikeMotley
New Member
- Joined
- Jul 13, 2012
- Messages
- 1
I have a growing log of sales activity where each row contains a Sales Stage, a $$ value, a sales rep name, and a date of creation. Each time a sale is progressed to the next stage, a workflow adds another row to the log containing. I want my reporting tool to create a history of "How much $$$ was in sales stage 2 on July 1? July 5? July 10?"
I have come close to what I need with this array formula:
"=MAX(IF(C1:C8=A1,D1:D8))
Where Column C houses the ID, D houses the purchase date and A1 houses the ID."
(thank you Jon)
but that does not filter my table, it only displays a Max date within a group, and I dont always want the max date I will need a history of each workday within the month.
Help!
I have come close to what I need with this array formula:
"=MAX(IF(C1:C8=A1,D1:D8))
Where Column C houses the ID, D houses the purchase date and A1 houses the ID."
(thank you Jon)
but that does not filter my table, it only displays a Max date within a group, and I dont always want the max date I will need a history of each workday within the month.
Help!