Lee D
Reputation: 1
Excel - find duplicates in column A and move the value to column B
If a value is found twice in column A, how do I put that value into the cell beside it in the next column?
Do I need vlookup?
Upvotes: 0
Views: 33
Answers (1)
Ralph
Reputation: 9444
You could copy the following formula into cell B1 and then copy the formula down (if I understood your question correctly):
=IF(COUNTIF(A:A,A1)>1,A1,"")
Upvotes: 1
Related Questions
- Find duplicates in column A, copy row and delete it
- Find duplicates in a column
- How to delete a columns duplicate cell value, and move up the other values in it's row
- Remove duplicates from column A based on existing values in column B using VBA
- removing duplicate values from a column
- Compare 2 columns and remove duplicates without shifting
- Excel - Filter unique values from Column A and move related values from Column B to other columns
- find duplicates in two columns and extract them to a new column
- Remove duplicate data from Column A on Excel and Move data From Column B
- Loop through column B foreach value in column A to find duplicates