Dynmic array (filter based on text)

[pmw19800]

Hello All

I need the formula in L2 to look at J1 and filter whatever is in J1,

please see attached to help explanation and understanding

thank you for looking

[Fluff13]

How about

Please Login or Register  to view this content.

although you need to get rid of the cells in ABC that have #N/A

[pmw19800]

changed the #N/A, its still not filtering tho

[Bo_Ry]

Please try

=SORT(FILTER(Table1,(IFERROR(Table1[ABC]=J1,0))*(Table1[Ext GL Cost]>=AGGREGATE(14,6,Table1[Ext GL Cost]/(Table1[ABC]=J1),K1))),8,-1)

[pmw19800]

thanks, Bo, that works great

have a great weekend

[Fluff13]

changed the #N/A, its still not filtering tho

works for me