• 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.

Assign The Same Number For Next Duplicates

Kenshin

Member
Hello ninjaz glad coming back here and need your assitance for clear explanation please see on the file attachment

thank you
 

Attachments

  • Example-1.xlsx
    9.9 KB · Views: 7
In C2 and pull down =IF(A2=A1;C1;COUNTIF($A$2:A2;A2))
Your numbering for Sales C does not seem correct. If it is please explain your logic in words
 
Thank you @pocoflyer for help the answer, yes Sales C is wrong, but what formula when the data is not sorted
 
As far as I can see, your data is not sorted, is it?
Again, please explain your logic in words. Thanks
 
Back
Top