Create a list based on dropdown criteria

[forestview]

Hi

Please see attached sheet.

I have been going in circles trying to find a way to build a formula in "Summary Sheet A3" which I can drag down and generate a list of invoice No's from the Account sheet but anything I have done to date gives me the numbers but with gaps in the rows, the formula needs to refer to the client dropdown Summary sheet A1.

Thank You

Forestview

[CK76]

In A3:
=INDEX(invoice_no,SMALL(IF(clients=$A$1,ROW(clients)-2),ROW(A1)))

Confirmed as array (CTRL + SHIFT + ENTER).

Edit: Nest it in IFERROR(,"") to remove #NUM! errors.

[forestview]

Hi CK76

That works fine however it also takes through the invoices with no cost (i.e. have been paid) can that be modified?

[Olly]

It would be easier to just use a pivot table. I'd add the "Days Over 30" to the source data.

See attachment for example, with pivot table in Summary!A21.

[forestview]

Thanks Olly kicking myself for not thinking of a pivot table

and thanks CK76 all help appreciated

Forestview