Excel function to Check neighbour cells match for all
Solved/Closed
Frank211
Posts
2
Registration date
Thursday June 4, 2015
Status
Member
Last seen
June 7, 2015
-
Jun 4, 2015 at 05:06 AM
Dan slow - Feb 25, 2016 at 08:12 AM
Dan slow - Feb 25, 2016 at 08:12 AM
Hi,
I need to check if (each) cell in column A is having a match in column B, Example as below:
Column A is phone numbers list, column B is messages list ( which will contain a text and one phone number "it should be the same phone number as the one on column A") Now i need to make sure that phone number on A1 is the same phone number that occure on B1,etc. I dont know how to check if A1 phone number is the same phone number on B1 ? or not, and apply the check for all cells in the column? it should show me only if it is not the same.
Many thanks in advance.
I need to check if (each) cell in column A is having a match in column B, Example as below:
Column A is phone numbers list, column B is messages list ( which will contain a text and one phone number "it should be the same phone number as the one on column A") Now i need to make sure that phone number on A1 is the same phone number that occure on B1,etc. I dont know how to check if A1 phone number is the same phone number on B1 ? or not, and apply the check for all cells in the column? it should show me only if it is not the same.
Many thanks in advance.
Related:
- Excel function to Check neighbour cells match for all
- Excel mod apk for pc - Download - Spreadsheets
- Check soft - Download - Finance
- Kernel for excel - Download - Backup and recovery
- Speaker check code - Guide
- How to check bios version - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 4, 2015 at 09:24 AM
Jun 4, 2015 at 09:24 AM
Franck211, good morning.
Try to use this:
C1 --> =IF(ISERROR(FIND(A2,B2)),"NOT FOUND","OK")
Copy it down.
Please, tell us if it worked for you.
Is it what you want?
I hope it helps.
Try to use this:
C1 --> =IF(ISERROR(FIND(A2,B2)),"NOT FOUND","OK")
Copy it down.
Please, tell us if it worked for you.
Is it what you want?
I hope it helps.
Jun 7, 2015 at 01:55 AM
Feb 25, 2016 at 08:12 AM