StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>If you have the count value all figured out and you know what sheet that they are located within in your workbook, you can use something similar to the following: Using the following data: Col A Col B Industry ProductVal A 11 B 45 C 22 D 9 E 8 F 12</p> <p>Assuming that you already have assigned 45, the largest value in column B to a cell, you can substitute the 45 below for that cell.</p> <pre><code> =INDEX(A2:B7,MATCH(45,B2:B7,0),1) </code></pre> <p>The above excel formula will return the value of B which is the value to the left of the "match value" of 45. A brief explanation is you define the index as the entire set of columns that are bounded on the left by the industry and on the right by the value. In the above example that was A and B. The Match then reads, find the value of 45 in the column B from row 2 - row 7 and match the first exact match (that is what the zero is for) and the 1 from the index function indicates that you will return the value that is in the first column (reading left to right) of the INDEX array A2:B7.</p> <p>You can find an <a href="http://office.microsoft.com/en-us/excel-help/index-HP005209138.aspx" rel="nofollow">explanation of index here</a>, an <a href="http://office.microsoft.com/en-us/excel-help/match-HP005209168.aspx" rel="nofollow">explanation of match here</a> and a nice explanation of <a href="http://office.microsoft.com/en-us/excel-help/dynamic-searching-using-vlookup-match-and-index-HA001154902.aspx" rel="nofollow">using them together</a> here.</p> <p>Best of luck.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload