I have the following data set in Column A of sheet 1.
CASE
1-123
1-123
1-123
5-001
1-111
1-123
1-001
I would like to return all consecutive duplicates & non-duplicates onto Column A of sheet 2. DESIRED OUTPUT:
CASE
1-123
5-001
1-111
1-123
1-001
This is what I've got so far.
I made a helper column. Next to the first CASE I put a 1. Below I put the formula =if(A3=A2,2,1).
CASE
1-123 1
1-123 2
1-123 2
5-001 1
1-111 1
1-123 1
1-001 1
I then entered the formula =INDEX(A2:B8,MATCH(1,B2:B8,0),1) which returned
1-123
5-001
5-001
5-001
1-111
1-123
1-001
Any help would be much appreciated!
Sorry for the ugly formatting, I'm using free Excel off OneDrive so I'm having issues downloading my spreadsheets.
Bookmarks