Marks and total on the basis of Roll No.

[arif]

Plz sirs

find here an attached sheet

i want such a conditional formual that if I insert Roll No. in Cell C20 then name of that particular student and his marks and total should auto be put against each field name

suppose I enter 1 C20 then there should be name "A" and marks should auto be added against subjects names and then total the marks

thanks in aniticipation

 

[Khalid NGO]

Hi Arif,

If you set-up your data like attached, you will get the desire result easily.
See Sheet2, i have converted your data in Table.

Regards,

 

[arif]

Sir

thanks for helpful tips and solution

now i want to attach two more columns to my data as i have in attached sheet

just suggest how can i go on roll no. based details like u suggested

and make correction in formula that i have used which is not working at all


thanks

 

[shaikhrulez]

Sir

thanks for helpful tips and solution

now i want to attach two more columns to my data as i have in attached sheet

just suggest how can i go on roll no. based details like u suggested

and make correction in formula that i have used which is not working at all


thanks

You have again posted the same file; @Khalid NGO has proposed a very decent solution to what you are looking for, it is better to make your data in a tabular format for making it more readable.

Anyways, check the attached file & see if this what you were looking for?

 

[arif]

plz find new file in new format and provide new solution

 

[arif]

thanks for all responses that i got from u now i have added two titles and rows so plz provide the best solution

 

[Deepak]

arif
Pls have same patience!
One will revert with the desired solution soon.

 

[Asheesh]

arif

does the attached help...