Hello,
Trying to create a row number for each row where there's data (not blank) for each Project Number and maintain the row count when an earlier Project Number reappears further down.
Here's an example:
Project Number TaskId Desired Result 998 T34 1 998 T43 2 998 998 T78 3 998 T90 4 998 998 T83 5 998 T83 6 999 T21 1 999 999 T83 2 998 T12 7
I'm thinking a combination of RANK and COUNTIFS is needed but can't wrap my head around this.
Bookmarks