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

Thread: Madad from Mr. Syar

  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 Madad from Mr. Syar

    Syar sahib main phir se files attatch kr rhi hon ply year columns ko base bna kr data duplicate aur uniqe alag alag kr dain dono files main se.
    Agr question ki samajh na aye tou plz phir se pooch kr kr dain.

    Thanks.
    Attached Files Attached Files

  2. #2
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default



    kia aap sirf year/jhar k column ko base bana kar duplicate aur unique alag karna chahte hain ya kisi aur column ko bhe add karna ha.

    regards

  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

    Only Year Column

  4. #4
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default

    But aap k year tu kai dafa repeat hue hain. is tarah tu aap ko wrong answer bhe mile ga.

  5. #5
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default

    Ok.
    Zamg ki file main aik column "A" insert karain aur ye formula a2 main lekhain aur neeche tak copy karain.

    =ISNUMBER(MATCH(B2,Euro_Cat_events_Austria.xls!$B$ 2:$B$1053,0))


    its not an elegant solution but try it and tell me. Jab tak main dosra hal soochta hon.
    Year k elawa aapke files main konsa colmn dosre se mukhtalif ho ga. Aur apna excel k version bhee batain.

    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

    Meray paas 2003 excel version hai. Actually main year ko hi base bna kr hi karna chahti hon kiun jo data year se agay duplicate ho ga woh sara aik jaisa ho ga main nay check kiya hai.Actaully main PhD main probablilstic seismic hazard analysis main work kr rhi hon.And its so nice of you to send me all the formulas which save my much time to work on it manually.
    Any ways I have another problen too I want vertical selection from notepad there is some keys i used in pakistan but forgot yet if you know then plz do write it too.

    Thanks.

    Allah Hafiz.

  7. #7
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default

    Ok take a look cat file main unique aur duplicte
    Attached Files Attached Files

  8. #8
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default

    zamg file main unique aur duplicate.

    allah hafiz
    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

    which technique you use to sort it out because i have lots of files to work on it

  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

    aur vertical selection ki short key bhi agr pta ho tou bta dain main net se search kr rhi hon mil nhi rahi

  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

    notepad file attatch kr rhi hon

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

    attatched

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. Final sheet for syar
    By sabir sami in forum Ask an Expert
    Replies: 2
    Last Post: 26th August 2011, 04:48 PM
  4. excel expert Syar Sb
    By sittarah in forum Ask an Expert
    Replies: 14
    Last Post: 28th January 2010, 05:45 PM
  5. swal to syar sahib
    By sittarah in forum Ask an Expert
    Replies: 20
    Last Post: 11th November 2009, 07:48 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
  •