=SUMPRODUCT((D38=$D$4:$D$201)*(I38<$I$4:$I$201))+1
I have this formula is Column B generating a number based on the number of times a word repeats down column D. But when the figure in column I Is not unique it repeats the number instead of generating a new one.
So I would get 1,2,3,4,4,4,4,8,9.
How can I alter this formula so that the second 4 becomes a 5 etc.
Info possibly required:
*Column D repeated word is always together so it might be bob 5 times then fred 9 times, then sally 3 times etc
*Column I is always highest to lowest number but the number could repeat. 10,9,8,8,8,7,6,6. The formula would return 1,2,3,4,5,6,7,8
I have this formula is Column B generating a number based on the number of times a word repeats down column D. But when the figure in column I Is not unique it repeats the number instead of generating a new one.
So I would get 1,2,3,4,4,4,4,8,9.
How can I alter this formula so that the second 4 becomes a 5 etc.
Info possibly required:
*Column D repeated word is always together so it might be bob 5 times then fred 9 times, then sally 3 times etc
*Column I is always highest to lowest number but the number could repeat. 10,9,8,8,8,7,6,6. The formula would return 1,2,3,4,5,6,7,8
