LinkBack URL
About LinkBacks
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!","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks