Hello,
I have a range of cells as project name and each project name appears in a different month
Each month +project have a different amount of sales, and I would like to get a formula that looks up for same project name in the range and if it exists, the true statement would be a diff between sales
Important:
1. I want a diff calculation between current and previous project appearance in the range
2. Unique project name can appear at most only once in a particular month ( or 0 or 1)
Thanks!
Bookmarks