I’m sure this is a case of not putting the right search string into Google, but it is Monday morning….
Say I have two columns of unsorted data A1:A10 and B1:10. I want to find, say the maximum in A1:10 and (Say, A7) output this value to A11….. but then I also want to know what the value is in the cell adjacent to the maximum in column A and output this to B11 (i.e the value in B7)…… and I want to repeat the process using the maximum in the column B data as well – I think this second requirement precludes using VLOOKUP? Any suggestions – that doesn’t involve manipulating the data again?
Thanks all – have done it (almost neatly) with a combination of INDEX to find the row reference for max/min and INDIRECT to make up the cell reference and output the values as needed generally across all columns.
R_B – point taken, and I will have to be careful of that, but as it is test data with something like 7 significant figures, duplication in ~100 rows is pretty small.