Hello,
There are names in 2 separate columns.
Column B:
Column D:
I want to list dissimilar data in both columns as UNIQUE and Case Sensitive.
I do this easily with Excel 365 functions. What I specifically want is how to do both case sensitive and unique comparison with ADO?
I would appreciate your help for the answer to my question.
Thank you.
There are names in 2 separate columns.
Column B:
| Kitap01.xlsm | |||
|---|---|---|---|
| B | |||
| 1 | Liste - 1 | ||
| 2 | Ayşe ÇAKIR | ||
| 3 | AYŞE ÇAKIR | ||
| 4 | Ayşe Çakır | ||
| 5 | Ayşe Çakır | ||
| 6 | Ayşe Çakır | ||
| 7 | AYŞE ÇAKIR | ||
| 8 | Murat ASLAN | ||
| 9 | Murat ASLAN | ||
| 10 | MURAT ASLAN | ||
| 11 | Murat Aslan | ||
| 12 | Mehmet ŞİMŞEK | ||
| 13 | MEHMET ŞİMŞEK | ||
| 14 | Mehmet Şimşek | ||
| 15 | MEHMET ŞİMŞEK | ||
| 16 | Nesrin SÖNMEZ | ||
| 17 | NESRİN SÖNMEZ | ||
| 18 | Nesrin Sönmez | ||
Sayfa1 | |||
Column D:
| Kitap01.xlsm | |||
|---|---|---|---|
| D | |||
| 1 | Liste - 2 | ||
| 2 | AYŞE ÇAKIR | ||
| 3 | Murat Aslan | ||
| 4 | Nesrin SÖNMEZ | ||
| 5 | Mustafa GÜRPINAR | ||
| 6 | AYŞE ÇAKIR | ||
| 7 | Nesrin SÖNMEZ | ||
| 8 | MUSTAFA GÜRPINAR | ||
| 9 | Selcan KAYA | ||
| 10 | Sevda USLU | ||
| 11 | SELCAN KAYA | ||
| 12 | Sevda USLU | ||
| 13 | MURAT ASLAN | ||
Sayfa1 | |||
I want to list dissimilar data in both columns as UNIQUE and Case Sensitive.
I do this easily with Excel 365 functions. What I specifically want is how to do both case sensitive and unique comparison with ADO?
I would appreciate your help for the answer to my question.
Thank you.
