LinkBack URL
About LinkBacks
begovics 
I have two lists of numbers. and I need to find duplicates, so I put them in columns A and B. Is there any way to sort them to appear in same rows (next to each other)?
I have two lists of numbers. and I need to find duplicates, so I put them in columns A and B. Is there any way to sort them to appear in same rows (next to each other)?
Are you looking for a solution to identify numbers that appear in both Column A and Column B? Or are you looking for a format that sorts the numbers? Because sorting the numbers might not be the best way to identify duplicates, depending on what you really need.
For a simple example, the following formula will show if a number in B1 is also found in Column A:
=IF(COUNTIF(A:A,B1)>0,"Duplicate!","")
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks