Results 1 to 8 of 8

Thread: Excel k expert hain to help karen plz

  1. #1
    zahid4942's Avatar
    zahid4942 is offline Senior Member+
    Last Online
    4th August 2022 @ 03:46 PM
    Join Date
    20 Mar 2010
    Location
    korangi
    Gender
    Male
    Posts
    469
    Threads
    120
    Credits
    1,478
    Thanked
    18

    Default Excel k expert hain to help karen plz

    mere pas aik excel ki file jis may first column may date format mix hay. mujhe date format 06-Dec-17 is format hay chaye. maine format par ja kr try kia par kujhse howa nhy. is sheet par may filter apply kar k month wise total dekhna chahta hn. plz koi expert help kare. or agar guide bhi kar de to asani hogi. sheet attached kr raha hn.
    Attached Files Attached Files

  2. #2
    khan3795 is offline Member
    Last Online
    28th March 2019 @ 01:46 PM
    Join Date
    19 Mar 2012
    Location
    Layyah
    Age
    34
    Gender
    Male
    Posts
    997
    Threads
    146
    Thanked
    44

    Default

    file ban gai hai upload kr deta hun

  3. #3
    zahid4942's Avatar
    zahid4942 is offline Senior Member+
    Last Online
    4th August 2022 @ 03:46 PM
    Join Date
    20 Mar 2010
    Location
    korangi
    Gender
    Male
    Posts
    469
    Threads
    120
    Credits
    1,478
    Thanked
    18

    Default

    Janab file to upload kar den. im waiting dear.

  4. #4
    Join Date
    19 Oct 2017
    Location
    Multan
    Gender
    Male
    Posts
    60
    Threads
    8
    Thanked
    2

    Question

    File Attached.... Enjoy


    http://pkalltricks.info/
    Attached Files Attached Files

  5. #5
    Join Date
    19 Oct 2017
    Location
    Multan
    Gender
    Male
    Posts
    60
    Threads
    8
    Credits
    808
    Thanked
    2

    Default

    if want year in 2 digits type "yy" to show year.
    if 4 digits required then type "yyyy"

  6. #6
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote zahid4942 said: View Post
    mere pas aik excel ki file jis may first column may date format mix hay. mujhe date format 06-Dec-17 is format hay chaye. maine format par ja kr try kia par kujhse howa nhy. is sheet par may filter apply kar k month wise total dekhna chahta hn. plz koi expert help kare. or agar guide bhi kar de to asani hogi. sheet attached kr raha hn.
    Ap ke file bilkul theek hai lekin aap sirf aik kaam karo
    aap date excel mai is tarah input karo
    mm/dd/yy
    1/2/17 i.e 02-Jan-17
    Desert Rose
    A Simple Person With Complicated Mind

  7. #7
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 03:57 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,305
    Threads
    412
    Credits
    39,745
    Thanked
    1813

    Default

    آپ کے پچھلے تھریڈ میں اس بات کا جواب لکھ دیا گیا ہے جو کہ اسی حوالے ۔۔۔۔۔مسلے کے بارے میں تھا

  8. #8
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    Kisi lambay chakkar mein parnay ki zaroorat nahi hai
    date k column ko select karo
    ctrl+h
    find what mein / type karo
    replace with mein - type kardo
    replace all par click kardo
    and enjoy

Similar Threads

  1. MS Excel ke expert help karen
    By zahid4942 in forum Ask an Expert
    Replies: 5
    Last Post: 17th November 2017, 09:28 PM
  2. Excel main date wise sort kasie karen?
    By Khushi1 in forum Ask an Expert
    Replies: 8
    Last Post: 7th January 2016, 05:58 PM
  3. khan gae expert jo khate hai it pe expert hain
    By azeemmahar in forum Mobile phones problems and Help Zone
    Replies: 2
    Last Post: 5th January 2015, 03:17 PM
  4. Excel Expert Plz Help Me...........
    By Stanha1989 in forum Ask an Expert
    Replies: 4
    Last Post: 28th November 2011, 08:51 PM
  5. need help ms excel expert
    By creative_eyes in forum Ask an Expert
    Replies: 1
    Last Post: 10th July 2010, 01:12 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
  •