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

Sorting data

razaas

Member
Another request for help, hope the below example is clear to understand and makes sense.

Thanks in advance.

Sheet1

Column-A Column-B

1 (Using formula: =COUNTIF($B$2:B2,B2) B-001

1 B-002

2 B-001

1 B-003

2 B-003


Sheet2

Column-A Column-B

B-001 1

2


Each row in column-B should show the number in sequence if match the data column B (Sheet1) with column A (Sheet2) . Should not list 1,1,2,1,2 as Sheet1, column-A.
 
Back
Top