Results 1 to 3 of 3

Thread: urgently help need about Excel

  1. #1
    smart yousufzai is offline Senior Member+
    Last Online
    5th December 2012 @ 07:11 PM
    Join Date
    18 Oct 2007
    Age
    42
    Posts
    192
    Threads
    51
    Credits
    0
    Thanked
    0

    Default urgently help need about Excel

    ITDUNYA K tamam seniors aur juniors ko mera salam.

    bhai mera sawal Microsoft Excel k mutalik hai mein ny ek sheet banai hai 2008 mein kiye gaye overtime ki takreeban 200 bandon ka overtime uss mei likha hai ab mei chahta ye hon k iss poril sheet mein koi aisa formula lagay k ya to woh khud hi serial mein ho jaye jaisay sab se pehly ajay jis ny sab se ziadah overtime kia ho 2008 mein phir uss k bad woh banda aajaye jis ny uss se kam kia ho phir iss tarah 200 bandon ka pata lag jaye k kiss ny ziadah kia hai.

    mein neechay kuch information de raha hon jo k ap ko samajh nay mein madad kary gi.


    A B C D E F G H I J K L
    JAN FEB MAR APRIL MAY JUN JUL AUG SEP OCT NOV DEC TOTAL

    1 zahid 5 50 75 40 35 11 80 90 55 60 27 45 573
    2 rahim 2 80 45 31 28 22 65 41 10 4 3 8 339
    3 kashif 90 70 140 60 70 80 55 30 90 130 50 55 920

    aisi hi ek sheet hai 200 bandon ki jo k mix mein chahta hon jis ny sab se ziadah overt time kia ha woh sab se upar ajaye phir uss se kam wala aur phir us se kam wala. to koi bata sakta hai k aisa koi formula hai Excel mein.

  2. #2
    Mubashar_ali's Avatar
    Mubashar_ali is offline Senior Member+
    Last Online
    25th November 2014 @ 12:37 PM
    Join Date
    17 Jan 2008
    Location
    Multan
    Gender
    Male
    Posts
    423
    Threads
    42
    Credits
    960
    Thanked
    4

    Default

    Proceed with steps 1,2 and 3. (See the picture attached)
    Attached Images Attached Images  
    I don't want to change the world, I just to change myself.

  3. #3
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Bhai Aap seedha seedha Total walay column par rakh kar sort kar dain ..tamam data sort ho jay ga ....

    1. L column "total" say lay kar 200 tuk select karain
    2. Date > Sort > Sort by -- Column L -- Decending

    agar masla ho to sheet share kar lain ..... main solve kar doon ga

Similar Threads

  1. Excel Help Urgently Needed
    By Musharraf_ms in forum Ask an Expert
    Replies: 0
    Last Post: 19th April 2014, 11:23 AM
  2. Excel Help....................... Urgently.....
    By ihsandani in forum Ask an Expert
    Replies: 3
    Last Post: 11th January 2014, 01:17 PM
  3. Solved Pls Help me Urgently (About Excel)
    By shahleopak in forum Solved Problems (IT)
    Replies: 5
    Last Post: 4th October 2011, 10:29 PM
  4. Excel problem pls help me urgently
    By shahleopak in forum Ask an Expert
    Replies: 13
    Last Post: 2nd December 2009, 09:57 PM
  5. Excel problem urgently help me
    By shahleopak in forum Ask an Expert
    Replies: 12
    Last Post: 6th August 2009, 08:51 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
  •