IF(sequence--backwards?

[CMLET]

Hi Gentleman and Ladies. Im trying a formula in D. (not too good)
My desired results are in Column C. of the Sample01: I'm looking to count backwards from each value in B. Example: Column A1 221, B1 96, C1 96.
Scroll to A188. Column B188 96, Column C188 95.
The Sample01 is a shortened version. Its approx. 12000 rows.
Thanks, CMLET

 

[vletm]

CMLET
What is meaning of A-column values?
What do You mean 'to count backwards'?
How did You get Your 'desired results' to C-column?

 

[bosco_yip]

Maybe…..........

1] In D1, formula copied down :

=B1-COUNTIFS(A$1:A1,A1,B$1:B1,B1)+1

2] However, in compare with the desired result column C and column D, out of 188 values 6 values were found mismatch.

3] Please check attached file

Regards
Bosco

 

[CMLET]

Hi Bosco. You are correct. I had manually entered the values incorrectly (6). The formula you have provided works beautifully. Thank You!