Forum Discussion
Excel- How to identify if number repeats and copy value into in a different column to another column
Hi There, I have an spreadsheet with many many rows and I would like to identify if the numbers in A column repeat and grab the values in C column and put it in different columns but same row. Please...
=TRANSPOSE(INDEX(C2:C11, MATCH(0, COUNTIF(J1:$J1, C2:C11)+IF(COUNTIF(C2:C11, C2:C11)>1, 0, 1), 0)))
Consider update your range and
Then press Shift + Ctrl + Enter keys