K Kinghart Member Jun 5, 2011 #1 hello Can anyone help me find the column number of the largest value in a set of values from A1:A7 I want to move some data from sheet1 to sheet2 using vlookup. but i want that to be the largest 3 numbers (only the largest 3) from the values in row 2:2
hello Can anyone help me find the column number of the largest value in a set of values from A1:A7 I want to move some data from sheet1 to sheet2 using vlookup. but i want that to be the largest 3 numbers (only the largest 3) from the values in row 2:2
dan_l Active Member Jun 5, 2011 #2 Sounds like an index/match thing. http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
Sounds like an index/match thing. http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
Luke M Excel Ninja Staff member Jun 6, 2011 #3 The column number of the largest value in A1:A7 will always be 1 (column A). Otherwise, something like: =MATCH(MAX(A1:F1),A1:F1,0) Might be helpful.
The column number of the largest value in A1:A7 will always be 1 (column A). Otherwise, something like: =MATCH(MAX(A1:F1),A1:F1,0) Might be helpful.