Find Duplicate text String if they are not in the same order

[sohail1966]

Dear Expert,
Mein ye maloom karna chahta hoo ke text string jo ke ho duplicate lekin un ka order same na ho, kyonke agar same order ho to wo asani se conditional format-->text hgillight--->duplicate value se highlight ho jati hain lekin baqi us ko manually dhoondhna parta hay aur agar data bohat ziada ho to bara time waste hota hay..
File attach kardi hay..
Bohat Bohat shukria..

[Haseeb Alamgir]

پہلے فلٹر لگا لیں سورٹ کر لیں پھرکنڈینشنل فارمیٹینگ کر لیں
آپ کا کام ہو جائے گا
اگر صرف اتناکام ہے تو
کوشش کریں پھر بتائیں

[sohail1966]

Bohat Bohat shukria Sir,
Yeh aik bohat bari file hay khali filter se kam nhi chalta, kyonke duplicate find karne hay jo hay to duplicate in the coloumn lekin inki tarteeb ulti seedhi hay.

[syar]

aik totka ha, tareqa main bata sakta hon mahnat aap ne krni ha. aur is dafa aap ne fees deni ho gi pahly.

[syar]

let suppose;
column D main aap d1 to D5 aap apny keywrod lekh laian for example;
SMD
kahna
commercial
Khayaban-e-Amin

Conditional formatting m jain, wahan p New rule define krain, wahan p formula k option ko select krain
aur ya formula laga lain. Formula ko apni zarorat k mutabiq modify kar lain.

=OR(COUNTIF(A1,"*"&$D$1:$D$10&"*"))

aap k jitne bhe rows hain us main kisi bhe tarteb sa ya keyword fall krty hongy wo highlight ho jaingy. ranges/reference aap modiy kar sakty hain. agar keyword ki list lambi ha tu formula m adjust kar lain.


iski fees aap ko Pizza khila kar deni ho gi. mjy aur hasseb sb ko

[sohail1966]

Syar Sahib Bohat Bohat shukria, ap address btaye mein wha pizo ke dhair lagwa deta hoon,
Ap ne itni itni mushkal problems ko hal karwaya hay to fees ka koi masla nhi....
Ap ka dia gia hal mein check karkay reply kar ta hoo..

[syar]

sirf kahny k leye ha k amal bhe krna ha aap ne is bat p????

[sohail1966]

Sir Ap hukam to krain..

[sohail1966]

Meine check kia tha aur ap ka totka shi kaam kar rha hay, lekin yeh bohat choti file par apply kia tha, ab main sare keywords ko search karkay is ko aik coloumn mein daal kar phir try kroonga.
Bohat Bohat shukria..
Screen short bhi share kar raha hoo.

[sohail1966]

Sir,
Yeh dono sides ki tmaam entries ko colour kardeta hay.
Jesa ke pichli post mei show kia tha aur mzeed screen shorts de raha ho..
Sukria...

[syar]

aap ka masla tu hal ho gaya, hamary maslay ka kya ho ga? wo fees wala chakar tu beech he m rah gaya???

[Haseeb Alamgir]

aap ka masla tu hal ho gaya, hamary maslay ka kya ho ga? wo fees wala chakar tu beech he m rah gaya???

چلیں بھئی مبارک ہو مسلہ حل ہوا
ایک
ہاہاہاہا