Webhosting in Pakistan
Results 1 to 8 of 8

Thread: How to trace Duplicate Contents in Excel

  1. #1
    Kaleem Nazeer is offline Senior Member+
    Last Online
    12th September 2019 @ 02:40 PM
    Join Date
    13 Jan 2007
    Age
    40
    Posts
    143
    Threads
    28
    Credits
    15
    Thanked
    6

    Default How to trace Duplicate Contents in Excel

    Webhosting in Pakistan
    As-salam-o-Alaikum! ALL ITD Members!

    Please reply in emergency.

    Thanks
    Attached Images Attached Images  

  2. #2
    syar is offline Advance Member
    Last Online
    17th September 2019 @ 08:57 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    42
    Gender
    Male
    Posts
    835
    Threads
    9
    Credits
    244
    Thanked
    340

    Default

    salam::
    I assume aap excel 2007 ya 2010 istimal kar rahe hain. Apne Column ko select karain aur

    Home Tab--->Conditional Fomatting---->HIghlight Cell Rules--->Duplicate Record.

    Ye aap ka column m tamam duplicate ko highlight kar d ga.

    Lekan aik problem ha Mere khayal m jo name aap cell me enter karte hain agar un ki spelling agar different ho gi tu excel is ko track nahee kar sake ga for example ahmad ya ahmed .. is masla ka hal ya ha k aap agar id card no ya koi aur no aap ki taraf sa jo alot kya jata ha is ko base bana kar kar sakte hain.

  3. #3
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    15,749
    Threads
    251
    Credits
    21,242
    Thanked
    1765

    Default

    آپ کا جو پہلا کالم ہے اس کو آپ تین حصوں / کالم میں تقسیم کر دیں یا کم از کم دو میں ضرور۔ واڈ نمبر جو ہے وہ سب کا الگ الگ ہوتا ہے میرے خیال میں تو آپ اس کو ڈیٹا شیٹ پر سب سے پہلے کالم میں رکھیں گے تو اوپر والے طریقے سے مطابق آپ کا مسلہ حل ہو جائے گا۔ اگر چاہیں تو رنگ کے زریعے بھی اس کو کنٹرول کیا جا سکتا ہے مگر شیٹ میں پہلا کالم واڈ نمبر کا ہی ہونا چاہیے۔

  4. #4
    Kaleem Nazeer is offline Senior Member+
    Last Online
    12th September 2019 @ 02:40 PM
    Join Date
    13 Jan 2007
    Age
    40
    Posts
    143
    Threads
    28
    Credits
    15
    Thanked
    6

    Default

    Bohat Shukriya Main isay try kar ke daikhta hoon. Phir batata hoon.

  5. #5
    Kaleem Nazeer is offline Senior Member+
    Last Online
    12th September 2019 @ 02:40 PM
    Join Date
    13 Jan 2007
    Age
    40
    Posts
    143
    Threads
    28
    Credits
    15
    Thanked
    6

    Default

    Main ne aap dono kay diye huwe tareeqay kay mutabiq apni sheet ko tarteeb dene ke baad formula apply kiya hai or kamyab bhi raha hai layqin meray pass kam az 200 se zayad entries hain jis ko oupar neechay kar ke yani scroll karwa kar dekhna parta hai jab ke main chahta hoon ke computer duplicate entry hotay he mujhe ous cell ka reference show kar de ke yeh entry pehlay se kis cell main mojood hai. Shukriya.

  6. #6
    Sazub's Avatar
    Sazub is offline Senior Member
    Last Online
    11th September 2014 @ 11:38 AM
    Join Date
    09 Dec 2010
    Location
    خب&
    Gender
    Male
    Posts
    3,339
    Threads
    229
    Thanked
    412

    Default

    syar
    السلامُ علیکم
    بہت عمدگی سے آپ نے مسلے کا حل بیان کیا ہے
    اللہ جی آپ کے علم میں مزید اضافہ فرمائیں آمین

  7. #7
    syar is offline Advance Member
    Last Online
    17th September 2019 @ 08:57 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    42
    Gender
    Male
    Posts
    835
    Threads
    9
    Credits
    244
    Thanked
    340

    Default

    Quote Kaleem Nazeer said: View Post
    Main ne aap dono kay diye huwe tareeqay kay mutabiq apni sheet ko tarteeb dene ke baad formula apply kiya hai or kamyab bhi raha hai layqin meray pass kam az 200 se zayad entries hain jis ko oupar neechay kar ke yani scroll karwa kar dekhna parta hai jab ke main chahta hoon ke computer duplicate entry hotay he mujhe ous cell ka reference show kar de ke yeh entry pehlay se kis cell main mojood hai. Shukriya.
    for your query visit the below link. This will certainly help you.

    http://www.itdunya.com/t100220/

    Please feed back.

    regards,

  8. #8
    Kaleem Nazeer is offline Senior Member+
    Last Online
    12th September 2019 @ 02:40 PM
    Join Date
    13 Jan 2007
    Age
    40
    Posts
    143
    Threads
    28
    Credits
    15
    Thanked
    6

    Default

    Webhosting in Pakistan
    Thanks Sayar Brother main try kar ke dekhta hoon. Umeed hai ke mera masla hal ho jayega. Shukria

Similar Threads

  1. Duplicate File Detective 2.2.0.0
    By rahmanrai in forum English IT Zone
    Replies: 14
    Last Post: 21st January 2020, 11:34 AM
  2. Excel may Formula ko Trace karna
    By flydreamz in forum Urdu Tutorials & Designing
    Replies: 45
    Last Post: 31st May 2016, 11:40 AM
  3. Excel main duplicate data alag karna
    By pearlsublime in forum Ask an Expert
    Replies: 1
    Last Post: 8th December 2009, 03:25 PM
  4. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •