SebastianHuang
New Member
- Joined
- Dec 5, 2019
- Messages
- 38
- Office Version
- 2013
- Platform
- Windows
Can anyone help me with this situation?
So I am comparing rows of data from two spreadsheets. Most of them will return true when I use the function =and(A1:F1=A1:F1). However some of them will return false when they are in fact the same. I suspect it is because I have a couple thousand lines of item I have to compare. When I copy and paste the false columns into another spreadsheet, and ran the test again, they all returned true. Is Excel broken in this sense? Thank you.
So I am comparing rows of data from two spreadsheets. Most of them will return true when I use the function =and(A1:F1=A1:F1). However some of them will return false when they are in fact the same. I suspect it is because I have a couple thousand lines of item I have to compare. When I copy and paste the false columns into another spreadsheet, and ran the test again, they all returned true. Is Excel broken in this sense? Thank you.