Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper 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