Hi,
I would like to be able to rank the deals based on the reps and the types of deals. Please see attached file for better understanding.
Thanks so much!
Hi,
I would like to be able to rank the deals based on the reps and the types of deals. Please see attached file for better understanding.
Thanks so much!
Have you tried to just sort the data - 1st by name, then by deal?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FDibbins,
Thank you for helping. Sorting is not an option because this is just one of the formulas in a very large spreadsheet. I would prefer a formula to help me achieve this.
Best,
Huy
I seem to have found the solution.
=IF(C:C="Roll-Over","None",IF(COUNT(D2),COUNTIFS(A:A,A2,C:C,"<>Roll-Over",D:D,">"&D2)+1,"None"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks