• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF(sequence--backwards?

C

CMLET

Member
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
 

Attachments

  • Sample01.xlsx
    15.2 KB · Views: 14
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?
 
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
 

Attachments

  • CountifsSample01.xlsx
    21.7 KB · Views: 7
Last edited:
Hi Bosco. You are correct. I had manually entered the values incorrectly (6). The formula you have provided works beautifully. Thank You!
 
You must log in or register to reply here.
Back
Top