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

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more