AFZAL SOHAIL
Board Regular
- Joined
- May 31, 2023
- Messages
- 156
- Office Version
- 2021
- 2016
- Platform
- Windows
Dear Team:
I have duplicate text strings in a column, when I find the duplicate through conditional formatting it is show easily if they are the same order, but which text string is not in the same
order it is not trace,
I share my a very little data is as under:-
The Text strings which are order is not same I color it blue..
I have duplicate text strings in a column, when I find the duplicate through conditional formatting it is show easily if they are the same order, but which text string is not in the same
order it is not trace,
I share my a very little data is as under:-
Sr.no | Text String |
1 | SMD: OLT-1 to C-43 Ichra Police Station |
2 | SMD: OLT-1 to C-43 Ichra Police Station |
3 | C-43 Ichra Police Station to SMD: OLT-1 |
4 | 8069-Kahna (11/0/2) to C-10K Royal Residencia |
5 | 8069-Kahna (11/0/2) to C-10K Royal Residencia |
6 | C-10K Royal Residencia to 8069-Kahna (11/0/2) |
7 | 8464-JTN-New to C-36 Broadway Commercial |
8 | 8464-JTN-New to C-36 Broadway Commercial |
9 | C-36 Broadway Commercial to 8464-JTN-New |
10 | WTN: C-29 Khayaban-e-Amin to C-20 119-A1 Valencia Society Zahra Graveyard |
11 | WTN: C-29 Khayaban-e-Amin to C-20 119-A1 Valencia Society Zahra Graveyard |
12 | C-20 119-A1 Valencia Society Zahra Graveyard to WTN: C-29 Khayaban-e-Amin |
The Text strings which are order is not same I color it blue..