excel - Call 'Large' ref, grab value from column in referenced row -


let's have few columns, 5 example. multiple rows. each individual row, on column , b, have 2 strings reference. columns c , d add column e, totals 2 values.

what i'm looking reference largest values in chart, pull number, , return 2 strings in columns , b.

i know can pull largest number in range x,y in col e =large(ex:ey,1), how 1 reference row number represents?

let's reference 2 strings in sixth row alpha , bravo, , sixth row contains largest value (26 example) want pull.

i'm looking way output 26 alpha bravo, if that's possible. i'm making list going largest smallest, i'm looking way incorporate large in there - looking pick 10 largest values , respective strings.

any thoughts?

i'm looking way output 26 alpha bravo, if that's possible.

please try:

=max(e:e)&" "&index(a:a,match(max(e:e),e:e,0))&" "&index(b:b,match(max(e:e),e:e,0)) 

Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -