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 customer phone number, customer address, customer place, Customer city 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 highlight them in colour or shown an message with column header mismatch values.
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 customer phone number, customer address, customer place, Customer city 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 highlight them in colour or shown an message with column header mismatch values.
Destination | Travel type | Customer id | Customer phone number | customer Address | Customer place | Customer city | Customer country | Status | reserved |
1234 | |||||||||
1234 | |||||||||
567 | |||||||||
890 | |||||||||
1234 | |||||||||
890 | |||||||||
1234 | |||||||||