1. ## 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 –

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.
Last edited by Nadeem Ahmed Kh; 29th October 2009 at 02:55 PM.

2. ## Request to Excel Expert

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 –

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

Last Online
17th September 2019 @ 08:57 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
835
9
Credits
244
Thanked
340

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

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

Last Online
17th September 2019 @ 08:57 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
835
9
Credits
244
Thanked
340

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 03:07 PM.

Last Online
17th September 2019 @ 08:57 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
835
9
Credits
244
Thanked
340

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

Last Online
17th September 2019 @ 08:57 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
835
9
Credits
244
Thanked
340

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

Thanks & regards

9. Dost lagta hai tum kuch close ho gaye

Last Online
17th September 2019 @ 08:57 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
42
Gender
Male
Posts
835
9
Credits
244
Thanked
340

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. Nahi Dost meri problem solved ho chuki hai, Mere kahne ka matlab kuch or tha, Ap ne bilkuc sahi solution diya hai

Thank

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•