since there is no real office forum and excel is close to vba which is close to vb i decided to post here

what i want is the following: i want the maximum "exp ende" of all entered levels ( or just the max of the max level )
in the screenshot it would be 38.961.947 of 69
or 65.124.876 of 70
or 67.886.629 of 72 ( which i care about the most, the most exp of the highest level )

i cant seem to get it working, does anyone have an idea?
https://dl.dropbox.com/u/20341785/Besitz/tableexcel.png
external link because the screenshot is huge

if u need any further info, please let me know

This post was edited by Dante on Nov 26 2012 02:40pm

probably better to post the xls so people can actually look at your shit and debug it. looking at the image/output does nothing.

great... right when i want to edit it wont let me anymore

this is the xlsx, it was made in german office though ( which has german function names) , i hope they somehow translate to english or something

when jsp puts it it in html tags i get 404, just copypaste the link...

This post was edited by Dante on Nov 26 2012 03:12pm

Is there a set range for the lvl? Are you looking for something like:

69.....38.961.947
70.....65.124.876
71.....0
72.....67.886.629

ugh forgot to post here, i found the solution
i just added a column that checks if the lvl is the maximum lvl, if it is, it takes the value over, otherwise its 0
that way i can find out the maximum of that

but thanks for the post
i

This post was edited by Dante on Nov 27 2012 10:32am