View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RobN[_2_] RobN[_2_] is offline
external usenet poster
 
Posts: 230
Default Conditional MIN value

There's probably a way to do this with a formula, but another way is to use
Filters.
I think this should work....
Apply filter to those columns then simply filter Column A to show only those
with HOV; filter column B for STK; filter column K for SELL, then filter
column N for the lowest value.

Rob

"Dallman Ross" <dman@localhost. wrote in message
...

I'm stuck and could use some help. I have a table with lots of
columns, one of which -- N -- is a price. I want to find the
minimum price where the value in Column A is "HOV" and Col. B is
"STK" and Col. K is "SELL".

Thanks for the quick hand at this, guys.