Compare Cell values from multiple cells under different rows and columns are same in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2988725%22%20slang%3D%22en-US%22%3ECompare%20Cell%20values%20from%20multiple%20cells%20under%20different%20rows%20and%20columns%20are%20same%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988725%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Need%20your%20help%20on%20the%20below%20query%3CBR%20%2F%3EI%20have%20excel%20file%20having%2020%20columns%20and%20100%20rows%3CBR%20%2F%3EIn%20the%20Column%20Customer%20id%2C%20if%20the%20id%20is%20same%20in%20different%20rows%20then%20i%20want%20the%20other%20corresponding%20row%20values%20to%20be%20same%20as%20well%20below%20is%20my%20example%3CBR%20%2F%3E1.%20%3CSTRONG%3ECustomer%20id%20-1234%3C%2FSTRONG%3E%20is%20same%20in%204%20rows%20so%20i%20want%20to%20check%20the%201.%3CSTRONG%3Ecustomer%20phone%20number%2C%202.customer%20address%2C%203.customer%20place%2C%204.Customer%20city%2C%205.customer%20county%3C%2FSTRONG%3E%20have%20same%20values%20in%20all%204%20rows%2C%3CBR%20%2F%3ESimilarly%20i%20want%20to%20check%20for%20other%20customer%20ID%20890%20which%20is%20common%20in%202%20rows%3CBR%20%2F%3EIf%20any%20mismatch%20in%20row%20values%3C%2FP%3E%3CP%3E1.%20highlight%20them%20in%20color%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20or%3C%2FP%3E%3CP%3E2.%3CSPAN%3Eshow%20the%20mismatch%20values%20in%20an%20message%20with%20column%20header%3C%2FSPAN%3E.%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bor%3C%2FP%3E%3CP%3E3.%3CSPAN%3EAuto%20correct%20the%20values%20taking%20it%20from%20first%20row.%20.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDestination%3C%2FTD%3E%3CTD%3ETravel%20type%3C%2FTD%3E%3CTD%3ECustomer%20id%3C%2FTD%3E%3CTD%3ECustomer%20phone%20number%3C%2FTD%3E%3CTD%3Ecustomer%20Address%3C%2FTD%3E%3CTD%3ECustomer%20place%3C%2FTD%3E%3CTD%3ECustomer%20city%3C%2FTD%3E%3CTD%3ECustomer%20country%3C%2FTD%3E%3CTD%3EStatus%3C%2FTD%3E%3CTD%3Ereserved%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E1234%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E1234%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E567%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E890%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E1234%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E890%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CDIV%3E1234%3C%2FDIV%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2988725%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi Need your help on the below query
I have excel file having 20 columns and 100 rows
In the Column Customer id, if the id is same in different rows then i want the other corresponding row values to be same as well below is my example
1. Customer id -1234 is same in 4 rows so i want to check the 1.customer phone number, 2.customer address, 3.customer place, 4.Customer city, 5.customer county have same values in all 4 rows,
Similarly i want to check for other customer ID 890 which is common in 2 rows
If any mismatch in row values

1. highlight them in color

      or

2.show the mismatch values in an message with column header.
     or

3.Auto correct the values taking it from first row. .

DestinationTravel typeCustomer idCustomer phone numbercustomer AddressCustomer placeCustomer cityCustomer countryStatusreserved
  
1234​
       
  
1234​
       
  
567​
       
  
890​
       
  
1234​
       
  
890​
       
  
1234​
      
0 Replies