Functions

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I have two columns, column A having the date and column B
having amount for that date. I can get the minimum amount
0 in column B, but I can't get the date that corresponds
Click to expand...
with the minimum amount > 0.
 
=INDEX(A1:A12,MATCH(SMALL(B1:B12,COUNTIF(B1:B12,0)
+1),B1:B12,0))

Change the ranges if necessary.

HTH
Jason
Atlanta, GA
 
Back
Top