FORMULA TO HIGHLIGHT CHANGES TO INFORMATION & insert new information

[juliew1961]

Hi, I have a large spreadsheet and I am sent information to update equipment numbers and other information contained within it.

I can provide a sample of the spreadsheet. Staff send in a copy of the information with manually highlighted fields and changed equipment names and numbers etc. I have to make note of the changes into a connector however highlight if a number in the spreadsheet changes.

Can someone help me with a formula to do a vlookup or hlookup to make this a faster process? There are 250,000 lines/equipment in the original excel spreadsheet that I have to check.

 

[J.Ty.]

Hi, I have a large spreadsheet and I am sent information to update equipment numbers and other information contained within it.

I can provide a sample of the spreadsheet. Staff send in a copy of the information with manually highlighted fields and changed equipment names and numbers etc. I have to make note of the changes into a connector however highlight if a number in the spreadsheet changes.

Can someone help me with a formula to do a vlookup or hlookup to make this a faster process? There are 250,000 lines/equipment in the original excel spreadsheet that I have to check.

Please post an example.

J.Ty.

 

[juliew1961]

Hi there,
I cannot insert the image or the file - any suggestions?

J

 

[FDibbins]

If you need to ID cells that have been manually colored, then no formula can do that, you will need VBA.

to find the row where a change was made, use MATCH...
=if(iserror(MATCH(A1,'[file-name.xlsm]sheet-name'!$A$1:$A$25,0))"Change","")
adjust ranges, file and sheet names to suite