plz help me

[jaadoogar]

dear friends maine excell main 2 shets banai hain.
ek Nov-09 jis main ek proforma banaya hai jis main name f/name grade waghaira hain.

or dosri grand total ki hai jis main class or total students k 2 colunms banai hain.

main yeh chahta hon k sheet 1 main jo bhi entry karon to woh agar grade (Class) 1 ki ho to dosri shet k class 1 main total student k colunm main 1 add ho jae agar do entries ho to 2 show kary. ese he jis jis class ki entry karon to woh us class k agy total entries show kary.

screen shots de raha hon dono shets k.

[*MALIK*]

Meray hayal may aisa mumkin nhi kyu k eik sheet ay likhnay se dusri may data kesay ja skta hai ho skta hai k ms acsess may aisa o sakta ho

[syar]

Bhai Aap ko aik masla hal karna ho ga. K aap ki 1 sheet m grade roman m ha aur dosri ma numbers main. Agar aik jese kar sakte hain yani roman ya number tu try this on sheet 2

=countif($d$69:$d$80,b114)

adjust sheet name and ranges. Aur agar dono aik se nahee kar sakte then reply m aap ko dosra hal batata hon jo k thoda sa mushkil ho ga.
2. Dosra agar aap Name ranges par kam karna jante hain tu DYnamic Named ranges define karain taka aap ko bar bar ranges change na karne pareaur aik he bar formula apply karne se aap ka kam automatic ho gae.

regards

[jaadoogar]

dear thanks for reply. magar us formuly se 0 return ho raha hai.
or main class names roman hata ker 1 2 3 ese ker k bhi lagaya hai magar return
0 ho raha hai.
main file send ker raha hon umed hai yeh dekh ker ap meri saheh se help ker paenge.

thanks

[syar]

But the same forumla works on your sheet. see attached sheet.
Agar grade master sheet m ho ga tu count ho ga jaise 1. agar nahee ho ga tu 0 he aae ga.

regards

[jaadoogar]

But the same forumla works on your sheet. see attached sheet.
Agar grade master sheet m ho ga tu count ho ga jaise 1. agar nahee ho ga tu 0 he aae ga.

regards

buhat buhat mehirbani syar bhai.
ap sabh ki buhat help kerty hain Allah ap ko iska ajar dega. Amen.

thanks

[syar]

My recomendation for you if you are a professional user of excel may be you already know.

1. You must know how to use relative and absolute refrences in a formula.
2. Use Named Ranges in your formula will save your time.
3. Agar mumkin ho aap k leye you must learn "Dynamic Named Ranges" ko kis tarah define karte hain aur kasie use karte hain.

Aap k is case aur is se pehle wale matter main my option wll be "Dynamic named ranges" (DNR).
Why?
Kion k agar aap kal koi new entry karte hain tu aap ko tamam formule manual adjust/amend karne paren ge. Jab k working with DNR give you a flexibilty to enter formula once it adjust ranges automatically.

Dosra agar aap xl2003 main table par kam karna jante hain tu its will be very easy for u.
Table ko xl2003 main "LIST" kaha jata hai. aap is ko ctrl+L, ya ctrl+T se activate kar sakte hain.

Hope you will never mind my suggestion.

Thanks & regards

[jaadoogar]

My recomendation for you if you are a professional user of excel may be you already know.

1. You must know how to use relative and absolute refrences in a formula.
2. Use Named Ranges in your formula will save your time.
3. Agar mumkin ho aap k leye you must learn "Dynamic Named Ranges" ko kis tarah define karte hain aur kasie use karte hain.

Aap k is case aur is se pehle wale matter main my option wll be "Dynamic named ranges" (DNR).
Why?
Kion k agar aap kal koi new entry karte hain tu aap ko tamam formule manual adjust/amend karne paren ge. Jab k working with DNR give you a flexibilty to enter formula once it adjust ranges automatically.

Dosra agar aap xl2003 main table par kam karna jante hain tu its will be very easy for u.
Table ko xl2003 main "LIST" kaha jata hai. aap is ko ctrl+L, ya ctrl+T se activate kar sakte hain.

Hope you will never mind my suggestion.

Thanks & regards

dear sir ap ki suggestion ko ham bhalla kaise galat ya mind ker sakty hain.
itni himat he nahin ham main.
khair ap ki suggestion buhat he achi hai. per sir mujhe excell main itna kam nahin ata bas jhugari kam kerta hon.
agar mujhe ap uska thora sa example de den tu main DNR sekh jaonga.

thank u very much