progress?!?

A

Alchemist

column A=wavelength <=
column B=absorbance 1
column C=absorbance 2
column D=absorbance 3
column E=absorbance 4 <= max(E200:E404)
Click to expand...

Ok, making some progress...

Is this closer?
=OFFSET(E200,MATCH(MAX(E200:BE404),E200:E404,0)-1,-5)

It returns a #ref! (but hey, at least now it recognizes the formula, so
that's an improvement!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time with VBA code 8
Finding dynamic maxima 9
Sumproduct? 3
Excel VBA macro, search - accumulate - delete original 0
lookup two different variables 0
Help with lots of formulas 3
Vlookup or similar 7
Formula than understands midnight? 26

Top