Return Aging Breacket

[Dave350z]

Hi,
I'm looking for a formula that will help return the latest aging bracket of per customer. In the sample, customer a should return 30-60, however, customer b should return 60-90 as their latest debt is showing in this age bracket.

Any ideas?

Thanks
Dave

[hoyasaxa215]

I'm not seeing anything you're discussing in the file you posted. It just has two CIDs (AB1 and AB2) and a few dates for each CID. Can you upload a file that shows the things you're talking about?

[shg]

Did you post the right workbook? There is no customer a or b, and the most recent date is 603 days ago.

[Dave350z]

Sorry, wrong one!

Thanks!

[shg]

	A	B	C	D	E	F	G
1		0-30	30-60	60-90	90-120
2	Customer a	0	400	0	0	30-60	F2: =LOOKUP(2, 1/(B2:E2<>0), $B$1:$E$1)
3	Customer b	0	200	200	0	60-90

[Dave350z]

Awesome, thanks!

I do need to do some work on lookups!!!

[shg]

You're welcome.