Page 1 of 2 12 LastLast
Results 1 to 12 of 21

Thread: swal to syar sahib

  1. #1
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default swal to syar sahib

    Syar sahib agr aik cell ko 2 ranges se match karna ho for duplication and uniqueness then formula kya banay ga
    jaisa kah ap nay formula btaya

    =if(isnumber(match(c2;range;range;0)); "duplicate";"Unique")

    The above formula will work for this or not.

    Thanks

  2. #2
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    No The above formula Will not work in this case need some adjustment. The formula ramian the same but after match you need to add "IF" condition.

    I'm not sure what is your exact scenario but a small sample help me out.

  3. #3
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Here is an approach for you.

    Suppose column e main
    a
    b
    c

    column F main
    b
    b
    b

    b1=
    =IF(ISNUMBER(MATCH(1,IF($E$1:$E$3=C1,IF($F$1:$F$3= C1,1)),0)),"duplicate","unique")

    where c1 houses your query.

    It is an array formula So must be confirm with "control+shift+enter" not just enter.
    Agar Ranges aik sheet m na hon alag sheet/file main tu adjust referenes

  4. #4
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default

    syar sahib ap ko jo 2 files main nay aphlay bhaiji thi us main aik masla ho gya hai actually main nay only year ko base bna kr duplicate dhondi thi lakin age aik file main aik dafa aik year likha hai aur dosri file main 10 dafa likha hai jabkah agay se record mukhtalif hai tou woh us ko duplicate show kray ga aur agr main year k saath saath month ko bhi check krna chahon for accuracy tou uss k liye ap kya formula suggest karain gay

  5. #5
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    here is a suggestion
    cat ki file m aik column add karain "A"
    a2=
    =C2&D2

    zamng ki file main do column add karain aur ye formula apply karain "A" & "B"
    b2=
    =D2&E2

    a2=
    =ISNUMBER(MATCH(B2,Euro_Cat_events_Austria.xls!$A$ 2:$A$1053,0))
    this formula return true & false

    agar match mila tu true "duplicate", aur na mila tu false yane "unique".

    kia aisa ho sakta ha k kisi dosri file m aap dono file m se 10 line alag alag sheets per lekh dain aur 3rd sheet par apna expected result manully lekh dain ta k mujh ko asani ho.

    hope this will help

    regards

  6. #6
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default

    check
    Attached Files Attached Files

  7. #7
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    check this file. apna data tru aur false ko bari bari filter laga kar copy kar alag copy kar dain.

    Kia formula ki jagha VBA code (MAcro) acceptable ha.
    Attached Files Attached Files

  8. #8
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default

    actually in any way the duplicate record should be same in both files but they are not I am again uploadind the files where i did something by using your hint. Plz check it out.one in this attachment and other in nest post
    Attached Files Attached Files

  9. #9
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default

    zip file attatched
    Attached Files Attached Files

  10. #10
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default

    i did same but duplicate records of both files are not same

  11. #11
    sittarah's Avatar
    sittarah is offline Senior Member+
    Last Online
    15th March 2021 @ 03:22 PM
    Join Date
    25 Nov 2008
    Location
    Vienna
    Posts
    266
    Threads
    59
    Credits
    1,133
    Thanked
    2

    Default

    even i added the day also can you point out the mistake i am doing

  12. #12
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    ok. main dekhta hon.figure out kar k aap ko reply karta hon.

Page 1 of 2 12 LastLast

Similar Threads

  1. Plz help in excel specially for syar
    By sabir sami in forum Ask an Expert
    Replies: 3
    Last Post: 20th May 2014, 04:19 PM
  2. Angry with me.syar
    By sabir sami in forum Ask an Expert
    Replies: 2
    Last Post: 29th August 2011, 11:39 AM
  3. excel expert Syar Sb
    By sittarah in forum Ask an Expert
    Replies: 14
    Last Post: 28th January 2010, 05:45 PM
  4. Madad from Mr. Syar
    By sittarah in forum Ask an Expert
    Replies: 17
    Last Post: 4th November 2009, 06:49 PM
  5. Moderator sahib aur admin sahib yi kia mazaq hai.
    By xplover in forum Tajaweez aur Shikayat
    Replies: 12
    Last Post: 28th July 2006, 04:37 PM

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
  •