Results 1 to 10 of 10

Thread: Access main madad chahyee

  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 Excel main madad chahyee

    Meray paas 2 data files hain unn k ander data hai main unn ko check karna chahti hon kah yeh data duplicate tou nhi hai matlab jo record aik file main hai wohi dosri file main tou nhi aur agr hai tou woh uss ko highlight kar day .aur duplicate ki alag se file banay aur jo data dono files main unique hai unn ki alag alag file ban gaye.

    Data files attatch kr rhi hon.Thanks.
    Attached Files Attached Files
    Last edited by sittarah; 21st October 2009 at 09:11 PM.

  2. #2
    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

    plz help me urgent

  3. #3
    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

    Please Excel or access expert help me

  4. #4
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    salam::

    aap konse column ko base bana kar duplicate aur unique deekhna chahte ain.

  5. #5
    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

    Thanks Syar Sahib I was waiting for your reply.Do colums hain aik year aur aik M hai jis ka matlab earthqauke magnitude hain shyed aik file main year deutch main Jahr likha ho. ya year k saath saath ap Intensity(I) ka column ly lain main nay access main duplicate tou query se dekhay hain lakin jo duplicate nhi hain woh main sort out nhi kr saki. Plz help me as early as possible. I am doing PhD and my project will go through after solving this problem.

  6. #6
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Post



    i'm not sure that I follow you.Kia aap eurocat file k column "B" aur "M" dono k value zong file k column "B" aur "M" saath compare karna chahte hain k dono match true ho tu duplicate agar na hon tu unique list ban gaey. Agar sirf column "B" ka saath compare karna ha tu zang file main aik new column insert karain aur ye formula a2 main copy kar k neech tak copy kar
    dain.
    phir apni list ko unuique ya duplicate k hisab se filter kar k new file/sheet main copy kar lain.


    =IF(ISNUMBER(MATCH(C2,Euro_Cat_events_Austria.xls! $B$2:$B$1053,0)),"duplicate","unique")

    agar ye aap ka solution nahee tu please screen shot main apna expected result dekha dain ta k samajhne m asani ho.

    2. aap apni zamg ki file dobara upload karain q k main ne do dafa load ki lekan mujhe file corrupt ka error milta ha.

    thank and regards.

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    see attached files
    Attached Files Attached Files

  8. #8
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Post

    salam::

    Aur agar aap dono column ka data aik dosre se match karna chahte hain tu follow this

    Euro_cat k file main aik column "A" insert karain.
    A2 main ye formula lekhain

    =C2&M2 aur copy down ( adjust column accordingly)

    zamg ki file main bhee aik coulmns insert karain
    A2 main ye formula insert karain aur copy down

    =IF(ISNUMBER(MATCH(C2&M2,Euro_Cat_events_Austria.x ls!$A$2:$A$65536,0)),"duplicate","unique")

    adjust column accordingly.

    ab aap filter laga kar apna unique aur duplicate data alag file main copy kar lain.



    agar euro cat ki file main bhee aap ko unique aur duplicate data darkar hai tu yehi procedure reverse repeat karain.

    Hope aap ka problem solved ho jae ga.

    regards

  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

    Thanks syar I will check it after university open it is closed till monday because monday is the public holiday in Austria.

    Or might be in next week because I am facing some health problem so I should admit to hospital.

    When I will check it then i will msg you till then keep cheking this thread plz its request.

    Allah Tallah ap ko iss belosse help ka ajar dy.Amin.

  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

    you may use the previous file of Zamg becuase its same as this file.

Similar Threads

  1. Answered M.S Word main Help Chahyee ...
    By Reporter in forum Solved Problems (IT)
    Replies: 11
    Last Post: 25th October 2012, 04:16 PM
  2. Excel main madad chahyee
    By sittarah in forum Ask an Expert
    Replies: 8
    Last Post: 17th July 2012, 04:57 PM
  3. HTC magic main madad chahyee
    By sittarah in forum Mobile phones problems and Help Zone
    Replies: 0
    Last Post: 24th February 2012, 10:37 PM
  4. Research paper download karny k liye madad chahyee
    By sittarah in forum Educational Help
    Replies: 0
    Last Post: 23rd December 2011, 11:36 PM
  5. Excel formula main help chahyee
    By sittarah in forum Ask an Expert
    Replies: 5
    Last Post: 8th October 2009, 10:52 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
  •