Find max marks from several xl sheets into a xl sheet

[gmx.krishna]

Hi all,

Plz do needfully for the subjected..

For Eg..

Sheet1 having All subjects Marks of Stud1
Sheet2 having All subjects Marks of Stud2
Sheet3 having All subjects Marks of Stud3
Sheet4 having All subjects Marks of Stud4
Sheet5 having All subjects Marks of Stud5

now in Sheet6, we have to find the Max(mark of sub1 from all sheets) and so..

Plz help, how to..

Thanks

Krishna

[dylanemcgregor]

I'm not sure I understand your question. Would it be possible for you to upload a sample Excel file where you show what the desired result is? (You can upload by clicking on the paperclip above the message box when posting your reply).

[mubashir aziz]

Try it ....

=MAX(Sheet1!<range>,Sheet2!<range>,Sheet3!<range>,Sheet4!<range>,Sheet5!<range>)

[br2566]

Krishna,

I understan your problem, you should try if else to solve this problem. If you still find problem upload your file i will check and change accordingly.

Regards,