Looking up value

  • Thread starter Thread starter D. Murphy
  • Start date Start date
D

D. Murphy

I am having a problem with a spreadsheet for portfolio values. The table is
layed out with each month being the next column. I want to find the min, and
then display the month that is associated with that minimum. I can't sort the
data since it is by month.
 
From a posting by Mike H. ONE line

=ADDRESS(MIN(IF(MIN(A2:E8)=A2:E8,ROW(A2:E8))),MIN(IF(MIN(A2:E8)=A2:E8,COLUMN(A2:E8))),4)
 
I tried the formula and it didn't work. I can also do it in VBA if anyone
knows how to get me there. All I want to do is find the minimum portfolio
value and then offset a few rows up to get the date that the min occurred.
 
If desired, send you file to my address below and I will take a look. One of
the things I am is a retired regional manager for ING. As such, I once held
a series 7 license.
 

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

Reference Formula Help 1
Copy and paste from levels 3
Lookup value from one sheet & show value in corresponding row of current sheet 1
How to find a result in an array in the same row as a minimum resu 3
Tracking Historic Data 4
Getting my chart to display dates 1
Help calculating trend by colours/taking last value per month. Thanks for all efforts 0
Odd Dynamic Range Question 6

Back
Top