Looking for duplicate numbers from one column
Solved/Closed
Donny
-
Feb 17, 2010 at 01:10 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Looking for duplicate numbers from one column
- Duplicate emails in two columns ✓ - Forum - Excel
- Duplicate values in multiple columns ✓ - Forum - Excel
- Excel - Search for duplicate in adjacent columns - How-To - Excel
- Delete duplicates in Excel: column, formula - Guide
- Compare columns and create list of duplicates ✓ - Forum - Excel
2 replies
rizvisa1
Feb 17, 2010 at 01:23 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 17, 2010 at 01:23 PM
You can try this
If two numbers are in A and B column
Then you can use match. In cell c2 you can write this
=IF(ISERROR(MATCH(B2,A:A,0)), "", MATCH(B2, A:A,0))
It will let you know what row has the same value is found in col A
If two numbers are in A and B column
Then you can use match. In cell c2 you can write this
=IF(ISERROR(MATCH(B2,A:A,0)), "", MATCH(B2, A:A,0))
It will let you know what row has the same value is found in col A
Mar 31, 2011 at 11:13 AM
Mar 31, 2011 at 11:16 AM
Apr 3, 2011 at 04:13 AM
thanks again or do you have other ideas? cheers
Apr 3, 2011 at 05:30 AM