Excel Help with comparing one file to another
Closed
Patricia Banks
-
25 May 2017 à 11:05
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 25 May 2017 à 16:17
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 25 May 2017 à 16:17
Related:
- Excel Help with comparing one file to another
- How to copy data from one excel sheet to another - Guide
- How to open .ps file - Guide
- How to merge and compare two excel files - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to open excel file in notepad - Guide
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
25 May 2017 à 14:38
25 May 2017 à 14:38
Patricia Banks, Good afternoon.
If the comparison is being made between different files, you have to point the names of the files in order to compare a cell from file 1 with a cell from file 2.
If the comparison is being made between different files, you have to point the names of the files in order to compare a cell from file 1 with a cell from file 2.
It is not being compared between different files. Both sets of data is in the same file on the same sheet.
Example:
=B3=L3
Same row just different column. I'm pretty sure it has something to do with format. I have cleared all formats and applied general to the entire data set. But still receive a False when I know they match.
Do you have any other ideas to try?
Thank you,
Patricia
Example:
=B3=L3
Same row just different column. I'm pretty sure it has something to do with format. I have cleared all formats and applied general to the entire data set. But still receive a False when I know they match.
Do you have any other ideas to try?
Thank you,
Patricia
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
25 May 2017 à 16:17
25 May 2017 à 16:17
Patricia, Good afternoon.
My suggestion to you occurred because you stated to us that you were comparing a file with another file.
"...Hello,
I am trying to see if file matches another file to make sure..."
Suppose you know that B3 matchs L3
Try to use:
M3 --> =IF(ISNUMBER(B3),"Number","text")
N3 --> =IF(ISNUMBER(L3),"Number","text")
The results will give you the type of data being compared.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
My suggestion to you occurred because you stated to us that you were comparing a file with another file.
"...Hello,
I am trying to see if file matches another file to make sure..."
Suppose you know that B3 matchs L3
Try to use:
M3 --> =IF(ISNUMBER(B3),"Number","text")
N3 --> =IF(ISNUMBER(L3),"Number","text")
The results will give you the type of data being compared.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
