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