Matching columns
Solved/Closed
Related:
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history.
- Orkut login gmail account - Guide
- Gmail login another account - Guide
- Delete whatsapp account without login - Guide
- Hi5 login old account - Guide
- Free fire account transfer - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 2, 2010 at 05:37 PM
Jun 2, 2010 at 05:37 PM
Try this
on column E, in you can have
=IF(ISERROR(MATCH(B2,A:A,0)), 0, MATCH(B2,A:A,0))
This will show the row number of where the account number in a cell of column B, appears in column A. In case the account is not in A column, it will show 0.
You can filter on 0 and delete the rows
on column E, in you can have
=IF(ISERROR(MATCH(B2,A:A,0)), 0, MATCH(B2,A:A,0))
This will show the row number of where the account number in a cell of column B, appears in column A. In case the account is not in A column, it will show 0.
You can filter on 0 and delete the rows
Jun 3, 2010 at 11:15 AM