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.
- Gmail login another account - Guide
- Orkut login gmail account - Guide
- Hi5 login old account - Guide
- Skype login history - Guide
- How to delete whatsapp account without login - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Jun 2010 à 17:37
2 Jun 2010 à 17:37
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
3 Jun 2010 à 11:15