need to print row locations where a value appears in a range

[neilosj]

Hi,

I have a list of around 1600 values, many are duplicated as they are part numbers in builds and as such many parts are common across many builds.
I have copied the list of parts and removed all duplicates in a new column, so I am left with a list of unique values that appear in the initial range.

I now need to search through the unique range and print beside it, in separate cells, the row numbers where the values appear in the original range.

There are around 500 unique values.
Attached is an example which should hopefully make sense.
**It seems I can't attach files, the menu doesn't work...
See screen shot...

range search.jpg

I have no idea how to do this sort of thing, so any help is appreciated.

[nankw83]

Welcome to the forum neilosj

Try below code based on attached pic...

Please Login or Register  to view this content.

[Fluff13]

Hi & welcome to the board.
You can do this with a couple of formulae, if you want.
In F6
=UNIQUE(A6:A21)
Then in H6 copied down
=TRANSPOSE(FILTER(ROW(A6:A21),A6:A21=F6))

[nigelog]

another basic method

Please Login or Register  to view this content.

[neilosj]

Amazing, thanks friends!
This has saved me many hours of potential manual, error prone work.