Excel Help with comparing one file to another
Closed
Patricia Banks
-
May 25, 2017 at 11:05 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 25, 2017 at 04:17 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 25, 2017 at 04:17 PM
Related:
- Excel Help with comparing one file to another
- Windows 10 iso file download 64-bit - Download - Windows
- Kmspico zip file download - Download - Other
- Transfer data from one excel worksheet to another automatically - Guide
- How to open an excel file in notepad - Guide
- Number to words in excel - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 25, 2017 at 02:38 PM
May 25, 2017 at 02:38 PM
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
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 25, 2017 at 04:17 PM
May 25, 2017 at 04:17 PM
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
