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

Thread: Excel Formula

  1. #1
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default Excel Formula

    Request to Excel Expert

    Dosto mere pas do fortnightly labour expenses details hai, Ek – 01.10.2009 se 15.10.2009 tak or Dusri 16.10.2009 se 31.10.2009 tak.

    Ab mai ye chahata hu ke dono fortnightly ke doran jo common head hai (Jese ke SN 1 - Store helper) wo to aaye hi lekin jo dono mai common nahi hai (Jese ke SN 20 Water proof plaster) wo bhi step by step ya randomly aa jaye (Ye sab ek dusri sheet mai) manually nahi kisi formula ke tahat.

    Sercondly me ye chahata hu ke en ka Amount jo hai wo bhi en head ke age sum hota jaye (Jese ke SN 1 mai (1680+1800) =3480 aa jaye


    Yane ke –

    SN Head = Total Amount
    1 Store helper = 3480.00
    20 Water proof plaster = 28764.00


    Mai ap sabhi ka sukrguzzar hunga

    For this, kindly go through the attached file.
    Attached Files Attached Files
    Last edited by Nadeem Ahmed Kh; 29th October 2009 at 01:55 PM.

  2. #2
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default Request to Excel Expert

    Quote Nadeem Ahmed Kh said: View Post
    Request to Excel Expert

    Dosto mere pas do fortnightly labour expenses details hai, Ek – 01.10.2009 se 15.10.2009 tak or Dusri 16.10.2009 se 31.10.2009 tak.

    Ab mai ye chahata hu ke dono fortnightly ke doran jo common head hai (Jese ke SN 1 - Store helper) wo to aaye hi lekin jo dono mai common nahi hai (Jese ke SN 20 Water proof plaster) wo bhi step by step ya randomly aa jaye (Ye sab ek dusri sheet mai) manually nahi kisi formula ke tahat.

    Sercondly me ye chahata hu ke en ka Amount jo hai wo bhi en head ke age sum hota jaye (Jese ke SN 1 mai (1680+1800) =3480 aa jaye


    Yane ke –

    SN Head = Total Amount
    1 Store helper = 3480.00
    20 Water proof plaster = 28764.00


    Mai ap sabhi ka sukrguzzar hunga

    For this, kindly go through the attached file.
    plsease solved it

  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

    Post


    Take a look at attached file (sheet NO.2). Kia aap ye chahte hain.

    1. Main ne aap ki origional file main dono data aik dosre k neeche copy ke hain jis se sheet 2 pe solution mumkin ho saka ha. Is k elawa bhe solved ho sakta ha per aap ke leye thoda sa mushkil hoga.

    2. All formula's applied on sheet 2 column B are arrays so must be confirmed with "control+shift+enter" not just enter. Its take 1 and half minute to calculate your sheet.

    3. Sheet 2 pa column b1 main data ko delete na karain warna aap ka sara data ghaib ho gaey ga.


    Agar solution dekhain. Agar ye na ho tu please screen shot dain k aap kia chahte hain.

    Regards & Thanks
    Attached Files Attached Files

  4. #4
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    That’s good, u r genius,

    Hai mai ye hi chahata tha,

    Dost kiya typical formulas ap ne apply kiya hai, sach mai imaging, mera sar chakragaya, Jawab nahi ap ka.

    Kiya koi easy formula nahi ho sakta jis se mai samajh ke further apply kar saku, wese ye bhi kuch kuch samajh a raha hai, but kuch chiz bilkul samajh mai nahi a rahi hai.

    Wese mari problem solved ho gai hai, lekin agar koi easily formula ho to bahot achcha hoga, Bhai.

    Mai ap ka or IT Dunya ka bahot bahut Sukrgujar hu.

    Apka NA Khan

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



    Thanks for your comment. Is formula k apply karna ki wajha ye the k aapka data 16K per row ha jo ka easily tackle nahee hota.

    AAp easily bhee is ko dosri sheet par copy kar sakte hain without formula.
    Sara data ko jaise main ne copy kia ha is tarah aik dosre k neeche copy karain.
    Sr. No k column ko delete karain. Aur phir advance filter===>unique values===>copy to another location select karain aap ka jitna bhee data ho wo duplicate k bagheer copy ho gaey ga.


    good luck,

    regards
    Last edited by syar; 30th October 2009 at 02:07 PM.

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



    Another Simple solution for you Agar aapko Name Define Karna Aata he tu?

    Apni labour expenses ki sheet par b3:b107 ko define karain as "list1".

    Now on Sheet2 (or anywhere else)

    B2:

    =INDEX(list1,MATCH(0,COUNTIF($B$1:B1,list1),0))

    Copy down until you get #NA error.
    Again Array formula so must be confirm "control+shift+Enter" but simple for you or any one who is concern.


    Ab aap mere aik cup of tea k karazdar ho gai.
    Hope this will help u in future.


    Regards

  7. #7
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Sukriya dost,

    Magar ek kami rah gai, Jo meri original sheet hai us mai unit ek head hai, dost bager unit ke apki or meri mahnat aadhuri rah jaigi, dost mai ye chahata hu ke mere tamam head ke agle column mai unit jo ke mene di hui hai wo bhi a jaye,

    Mene ye try kiya tha but ye kam nahi ho raha, ap ke formula meri samajh se bahar hai. InsaAllah ap ke liye 3 cup tea mujh pe due hai, lekin ap ki es ke liye India aana hoga, dost ---- Welcome to India/New Delhi/Jamia Nagar/Okhla/Abul Fazal Enclave Part-II, Shaheen Bagh/C-58/1

    Welcome – Welcome

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

    Post



    Attached file ki sheet1 aur 2 ko deekhain. Jo aapko asan lage use apna lain.


    Thanks & regards
    Attached Files Attached Files

  9. #9
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Dost lagta hai tum kuch close ho gaye

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



    Bhai mere samajhne k leye aap aisa karo k apni file dobara attached karain. Sheet 2 main aap jo result chahte ho wo w/o formula 5 ya 7 line lekh dain ta ka mujh ko samajhne main asani ho. Dosra aap xl ka konsa version istimal kar rahe hain. If 2003 ya 2007 then i have tip for you.

    regards

  11. #11
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Nahi Dost meri problem solved ho chuki hai, Mere kahne ka matlab kuch or tha, Ap ne bilkuc sahi solution diya hai

    Thank

  12. #12
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Keir ek bat bataye wo ye ke kiya Excel mai hand tool aa sakta hai kisi tarha se, taki ham apni excel ki file ko hand tool se move kar sake, kiyoki excel ki koi koi file bahot badi hoti hai to kabhi kabhi lagta hai ke hand tool ho jesa ke adobe reader mai hota hai, Agar possible ho to please ......... bataye

    Sukriya Dost

Page 1 of 2 12 LastLast

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. Excel formula
    By naeemshahzad in forum Ask an Expert
    Replies: 0
    Last Post: 22nd March 2015, 12:22 PM
  3. Excel Formula Help
    By adnanmomin in forum Ask an Expert
    Replies: 4
    Last Post: 31st May 2013, 06:38 PM
  4. help a Excel formula
    By Ameen Asim in forum Ask an Expert
    Replies: 0
    Last Post: 6th May 2012, 04:08 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
  •