I have a spreadsheet with names of software in A, I want to find exact matches in the same column and if match is found put the contents of A cell in B cell.
I have a spreadsheet with names of software in A, I want to find exact matches in the same column and if match is found put the contents of A cell in B cell.
Put in cell B1
=IF(COUNTIF($A1:$A$9,$A1)>1,$A1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks