Return Minimum value with multiple criterion

[brycer]

Hello,
I'm working on creating a formula to tell me the oldest outstanding invoice based on Job #. I have a pivot table that shows an outstanding amount, if any, for each invoice. Each customer has multiple invoices.

Ideally, the user would input the job #, and the formula would return the oldest outstanding invoice for that specific job.

The minimum (date) value would be returned after meeting to criterion:

1. Job numbers need to match
2. Open amount > $0

I tried (and failed) with the formula below:

=IF(AND(P:P=$V1,S:S>1),MIN(R:R),"")

Where V1 is the Job# input, Column P is the list of Job #'s, Column S is the Open Amounts, and Column R is the dates.


Any help is appreciated, thanks!

 

[JoeMo]

Excel Workbook
	P	Q	R	S	T	U	V
1	Job #'s	other	Date	Amount		job #	1234
2	9819		6/26/2019	61		Oldest	6/14/2019
3	8170		6/18/2019	19
4	6090		6/12/2019	43
5	3606		6/17/2019	36
6	1234		6/21/2019	28
7	3399		6/13/2019	98
8	6598		6/22/2019	6
9	1234		6/16/2019	72
10	9939		6/20/2019	86
11	4420		6/25/2019	52
12	9488		6/19/2019	32
13	1234		6/24/2019	0
14	1234		6/14/2019	33
15	1610		6/15/2019	25
16	8103		6/23/2019	8
Sheet8

 

[brycer]

Thank you JoeMo!!

 

[JoeMo]

Thank you JoeMo!!

You are welcome - thanks for the reply.