Nov 20 2021 07:58 AM
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. .
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 |