Matching identical datas of two coloumns
Closed
SAM
-
Jun 7, 2010 at 02:39 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 05:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 05:47 AM
Related:
- We couldn't find an account that matches what you entered but found one that closely matches
- Can we transfer free fire account from facebook to google - Guide
- How long does facebook take to review disabled account - Guide
- Xbox one guest account not working - Guide
- Can we change free fire google account to facebook - Free Fire
- We saw unusual activity on your account. this may mean that someone has used your account without your knowledge. - Facebook Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 05:47 AM
Jun 7, 2010 at 05:47 AM
let say the two columns are A and B then you can use
in C
=IF(ISERROR(MATCH(A1, B:B, 0)), 0, MATCH(A1, B:B, 0))
This gives you the row number of column B, where the value of cell A1 was matched. if no match was found, then it gives you zero
in D you can have
=IF(ISERROR(MATCH(B1, A:A, 0)), 0, MATCH(B1, A:A, 0))
Which will show row number of column A, where the value of cell B1 was matched, If no match was found, then 0
You would have to drag the formula to the last rows
in C
=IF(ISERROR(MATCH(A1, B:B, 0)), 0, MATCH(A1, B:B, 0))
This gives you the row number of column B, where the value of cell A1 was matched. if no match was found, then it gives you zero
in D you can have
=IF(ISERROR(MATCH(B1, A:A, 0)), 0, MATCH(B1, A:A, 0))
Which will show row number of column A, where the value of cell B1 was matched, If no match was found, then 0
You would have to drag the formula to the last rows
