Results 1 to 6 of 6

Thread: MS Excel ke expert help karen

  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 MS Excel ke expert help karen

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

    Itdunya may koi expert nhy hay kya jo ye problem solve kar de.

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

    Aap ne kuch entries "/" k sath ki hain jis ki waja sa format cell ise change naee kry ga. aap ko ise manual thk krna pary ga. ya ayanda jab aap entries karin tu "mm-dd-yy" k format main karain.

    Month wise Filter wese beh apply ho jay ga. Filter lagany k bad total maloom krny k leye aap ko SUBTOTAL ka formula use krna pary ga. e.g.
    =subtotal(109, 'yourraange)

    subtotal ka function sirf us cell ko sum kary ga jo k filter ki waja sa visible hongi.

    regards,

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

    maine sab entries "/" k sath hi ki hain check karne k lye format par ja kar date format change ki to kuch change ho gi or kuch nhy.

  5. #5
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,306
    Threads
    412
    Credits
    39,750
    Thanked
    1813

    Default

    جو تاریخ تبدیل نہیں ہوئی ہیں اُن کو دوبارہ سے انٹر کر لیں
    دوبارہ سے انٹر کرنے سے پہلے سیل کو۔۔۔سیل فارمیٹ میں جا کر ۔۔۔۔۔ڈیٹ۔۔۔۔اور۔۔۔اُس کی فارمیٹ اپنی پسند کا کر لیجیےگا
    پھر
    ٹھیک ہو جائے گی

  6. #6
    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. Excel main date wise sort kasie karen?
    By Khushi1 in forum Ask an Expert
    Replies: 8
    Last Post: 7th January 2016, 05:58 PM
  2. Koi ms excel expert hay?
    By sanafaiz in forum Ask an Expert
    Replies: 1
    Last Post: 20th February 2014, 04:18 PM
  3. M.s EXCEL EXPERT HELP
    By DjRashid95 in forum Ask an Expert
    Replies: 2
    Last Post: 2nd February 2014, 12:48 PM
  4. Solved MS Excel expert plz help
    By Sajid286 in forum Solved Problems (IT)
    Replies: 9
    Last Post: 21st July 2012, 10:03 PM
  5. MS Excel Expert, help plz
    By Hafeez194 in forum Ask an Expert
    Replies: 4
    Last Post: 14th January 2011, 07:28 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
  •