Data validation and vlookup

[arif]

Suppose i have data like this

eng. scie math total
a 25 30 22
b 12 45 49
c 34 42 50
d 44 32 33

What i want is when i sum the total marks or change marks in a subject the first ranke should automatically be displayed in first row along with marks and second in 2nd and vice versa

one more thing when i want to know the marks of "a" student no other students' marks should be displayed

i expect to help in both these matters

 

[Luke M]

Hi arif,

I would create a PivotTable from your data. Sort the PT descending by Total Sum. Now, when you change the data (and refresh the PT), values will be in correct order. PT also gives you the option to filter down as desired.

 

[arif]

Hi arif,

I would create a PivotTable from your data. Sort the PT descending by Total Sum. Now, when you change the data (and refresh the PT), values will be in correct order. PT also gives you the option to filter down as desired.

Awaiting Ur response

thanks

 

[Luke M]

Hi arif,
I believe the the "ball is in your court". I have given a response already...I'm not sure if idea is acceptable or not to you. Or if you've already tried it. Or if you can provide a sample of your data to better allow us to give a better response. Until then, I will continue to work on my mind-reading skills, but no promises.

 

[Khalid NGO]

Hi Arif,
See the attached sample and inform it helps or not.

use conditional formatting if you don't want to display student other than a.

Regards,