A B X1 16 X2 17 X2 18 X2 19 X3 21
I have two columns as above.
If there are duplicates in Column
A (here the duplicate value is "X2"), then I need to insert in another sheet:
- value "18" - i.e. second value of duplicates
- value "19" - i.e. subsequent value(s)
How can I find duplicates in column
A, and then for all duplicates except the first one from each group, get the values from a different column?
I have tried with many IF, FIND formulas, but nothing seems to work.