kameron1967
New member
- Joined
- May 31, 2018
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi,
I wonder if someone could help me compare 2 files with 5 columns of information. I'd like to first identify and highlight the data on the first column, under POINT NUMBER, and highlight if spreadsheet2 has the same information as spreadsheet1. If it's easier, I could copy the information and only compare between sheet1 and sheet2.
In addition to highlighting the same information on sheet1, I'd like to also highlight the information that's different for columns B, C, D and E. Basically, if the information on sheet1, column A, has point string, LE_000_OCD_27007 on row 8, and if sheet2 has the same information on column A, but on a different row, then I'd like the routine to compare the rest of the columns for differences.
The column headers would be:
POINT NUMBER, Y, X, Z, DESCRIPTION.
Point number and description contains alphanumeric info.
X, Y and Z contains only numbers.
Thank you.
I wonder if someone could help me compare 2 files with 5 columns of information. I'd like to first identify and highlight the data on the first column, under POINT NUMBER, and highlight if spreadsheet2 has the same information as spreadsheet1. If it's easier, I could copy the information and only compare between sheet1 and sheet2.
In addition to highlighting the same information on sheet1, I'd like to also highlight the information that's different for columns B, C, D and E. Basically, if the information on sheet1, column A, has point string, LE_000_OCD_27007 on row 8, and if sheet2 has the same information on column A, but on a different row, then I'd like the routine to compare the rest of the columns for differences.
The column headers would be:
POINT NUMBER, Y, X, Z, DESCRIPTION.
Point number and description contains alphanumeric info.
X, Y and Z contains only numbers.
Thank you.