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
 
You must log in or register to reply here.

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

Access Running Balance in Access 1
Date and amount of last payment 3
How to sum values between dates 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How can I update macro to delete zero amount columns? 2
summing transactions based on date 4
Access #Error & Excel Pivot 0
SUMIF. 1

Back
Top