Results 1 to 9 of 9

Thread: Excel main date wise sort kasie karen?

  1. #1
    Khushi1 is offline Senior Member+
    Last Online
    24th April 2018 @ 09:49 AM
    Join Date
    04 Nov 2012
    Location
    ~Najany Kahan~
    Gender
    Male
    Posts
    289
    Threads
    31
    Credits
    64
    Thanked
    13

    Default Excel main date wise sort kasie karen?

    Asslam O Alaikum

    Meray pas aik list hai jis main Employee ki date of appointment neechay di gaye tarteeb sey likhi hue han. En ko main date wise sort out karna chahta hoon k sab sey purani date par kis ki appointment hue hai jo date sab sey upar aa jaye jab k sab sey newest date ka appointed employee sab sab sey neechay bottom main aa jaye. is ko sort out kaise karna hoga, koi dost rehnumai farma dain, list neechay di gaye hai.
    13-08-2013
    1/10/2015
    24-08-2014
    8/1/2015
    1/1/2014
    1/1/2014
    15-08-2014
    12/1/2014
    23-06-2014
    27-09-2014
    19-01-2014
    18-07-2013
    26-02-2014
    18-06-2014
    10/1/2014
    20-11-2014
    12/1/1999
    15-09-2014
    20-02-2014
    4/9/2014
    19-09-2014
    21-10-2015
    28-12-2014
    24-09-2013
    18-06-2013
    20-09-2013
    30-11-2013

    Thanks

  2. #2
    Hamid Ali. is offline Junior Member
    Last Online
    9th January 2016 @ 08:40 AM
    Join Date
    03 Jan 2016
    Age
    31
    Gender
    Male
    Posts
    9
    Threads
    1
    Credits
    0
    Thanked
    0

    Default

    tooooo?

  3. #3
    Join Date
    21 Dec 2008
    Location
    Faisalabad
    Age
    41
    Gender
    Male
    Posts
    2,588
    Threads
    104
    Credits
    4,372
    Thanked
    173

    Default

    Quote Khushi1 said: View Post
    Asslam O Alaikum

    Meray pas aik list hai jis main Employee ki date of appointment neechay di gaye tarteeb sey likhi hue han. En ko main date wise sort out karna chahta hoon k sab sey purani date par kis ki appointment hue hai jo date sab sey upar aa jaye jab k sab sey newest date ka appointed employee sab sab sey neechay bottom main aa jaye. is ko sort out kaise karna hoga, koi dost rehnumai farma dain, list neechay di gaye hai.
    13-08-2013
    1/10/2015
    24-08-2014
    8/1/2015
    1/1/2014
    1/1/2014
    15-08-2014
    12/1/2014
    23-06-2014
    27-09-2014
    19-01-2014
    18-07-2013
    26-02-2014
    18-06-2014
    10/1/2014
    20-11-2014
    12/1/1999
    15-09-2014
    20-02-2014
    4/9/2014
    19-09-2014
    21-10-2015
    28-12-2014
    24-09-2013
    18-06-2013
    20-09-2013
    30-11-2013

    Thanks
    Yeh lo Sort Kr diya

    12-01-99
    18-06-13
    18-07-13
    13-08-13
    20-09-13
    24-09-13
    30-11-13
    01-01-14
    01-01-14
    10-01-14
    12-01-14
    19-01-14
    20-02-14
    26-02-14
    18-06-14
    23-06-14
    15-08-14
    24-08-14
    04-09-14
    15-09-14
    19-09-14
    27-09-14
    20-11-14
    28-12-14
    08-01-15
    01-10-15
    21-10-15

  4. #4
    MALIK R1ZWAN's Avatar
    MALIK R1ZWAN is offline Advance Member+
    Last Online
    5th December 2020 @ 03:07 PM
    Join Date
    28 Dec 2015
    Location
    Earth
    Age
    23
    Gender
    Male
    Posts
    885
    Threads
    50
    Credits
    8,579
    Thanked
    115

    Default

    Quote loyal_cupid said: View Post
    Yeh lo Sort Kr diya

    12-01-99
    18-06-13
    18-07-13
    13-08-13
    20-09-13
    24-09-13
    30-11-13
    01-01-14
    01-01-14
    10-01-14
    12-01-14
    19-01-14
    20-02-14
    26-02-14
    18-06-14
    23-06-14
    15-08-14
    24-08-14
    04-09-14
    15-09-14
    19-09-14
    27-09-14
    20-11-14
    28-12-14
    08-01-15
    01-10-15
    21-10-15
    بہت ہی اچھے دوست


    Punjabi Tigers Rock's

  5. #5
    Khushi1 is offline Senior Member+
    Last Online
    24th April 2018 @ 09:49 AM
    Join Date
    04 Nov 2012
    Location
    ~Najany Kahan~
    Gender
    Male
    Posts
    289
    Threads
    31
    Credits
    64
    Thanked
    13

    Default

    bhai aap mujhe is ko karne ka step by step tariqa bata dain kyun k main nay name wise list sort karni hai?

  6. #6
    Join Date
    06 Jan 2014
    Location
    Saudi , Makkah
    Age
    30
    Gender
    Male
    Posts
    3,178
    Threads
    304
    Credits
    2,092
    Thanked
    443

    Default

    bhai simple ap sare ko select karo naam k sath us k baad ap sort & filter k aption ma jao or custom k option ma ja k sort kar do easily ho jaiy ga...ok

  7. #7
    Khushi1 is offline Senior Member+
    Last Online
    24th April 2018 @ 09:49 AM
    Join Date
    04 Nov 2012
    Location
    ~Najany Kahan~
    Gender
    Male
    Posts
    289
    Threads
    31
    Credits
    64
    Thanked
    13

    Default

    bhai us main date wise change nahi ho rahi hai main nay check kiye han tamaam options. Means jis Employee ki Appointment sab sey Pehlay hue hai main us ko list main Top par rakhna chahta hoon, jab k jis ki appointment sab sey last main hue hai us ko main list main name wise bottom par rakhna chahta hoon?

  8. #8
    Khushi1 is offline Senior Member+
    Last Online
    24th April 2018 @ 09:49 AM
    Join Date
    04 Nov 2012
    Location
    ~Najany Kahan~
    Gender
    Male
    Posts
    289
    Threads
    31
    Credits
    64
    Thanked
    13

    Default

    kisi ko nahi pata

  9. #9
    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:

    Assume k aap Excel 2007,2010 ya 2013 use kr rahe hain

    1.Apne Data ko select karain. ya srf 1s heading p curson rakhain
    2. MENU m "DATA" k tab m jain
    3. Sort par click krain
    4. aik new window open ho gi aur aap ka tamam data automatic select ho jai ga.
    Aap notice karainge k pahly drop down p sort lekha ho ga. is ko open karainge k tu aap ko multiple option milainge. jo k aap ki headings honge. aap is m sa jis column ko sort krna ha use select karain. aap k case m date of Appointment ya aap n jo bhe heading di ho.

    5.2nd drop down ko chor dain aur 3rd drop down jis p order lekha ho use open karain. aap ko 3 option milainge. 1. oldest to newest 2. Newest to oldest 3. custom
    Oldest sa newest ko select karinge tu aap ka tamam data date wise sort ho jai ga. yane purane dates pahly aur new dates bad m aainge. try

    aap try kr k dekh lain. ya yahan p apni file share kar dain.

    regards

Similar Threads

  1. EXCEL MAIN DATE KA MASLA
    By faizan374 in forum Ask an Expert
    Replies: 2
    Last Post: 17th September 2015, 12:10 AM
  2. How to Sort a photos Face/Group wise in windows
    By bigbose in forum Ask an Expert
    Replies: 0
    Last Post: 17th February 2014, 02:37 PM
  3. Sort in excel
    By adnanbahrian in forum Ask an Expert
    Replies: 1
    Last Post: 2nd January 2014, 04:06 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
  •