How to sort a filtered array from another sheet?

[jeffreyESNW]

Scenario:
Sheet1 = Parent sheet
Sheet2 = Child sheet generated from filtering Sheet1 using =FILTER(IF(FINAL!A2:AC2000="","",FINAL!A2:AC2000),FINAL!P2:P2000>=62)

This works fine, however I have no way to sort this autogenerated Sheet2. I get the error "You can't change part of an array"

GOAL:
I want to sort the output of Sheet2 by the ages in column P while mainting the auto-updates that Sheet2 gets when making changes to Sheet1. If you know how I can modify =FILTER(IF(FINAL!A2:AC2000="","",FINAL!A2:AC2000),FINAL!P2:P2000>=62) to get that to work I'd really appreciate it.

Thank you for the help!

[TMS]

One way:

Please Login or Register  to view this content.

[jeffreyESNW]

I appreciate the help, but that doesn't seem to work. I'm getting rows where that value in P that needs to be >=62 that are way LESS than 62...

[TMS]

You have the advantage of me in that you have a workbook with data and I just made something up.

[jeffreyESNW]

You have the advantage of me in that you have a workbook with data and I just made something up.

My original equation doesn't throw anything sub 62? Ya if it wasn't a giant excel book with customer info I'd post it. If I can't get it resolved I guess I can sanitize it and upload...
Thanks for trying to help, appreciate it!

[TMS]

No, my bad. I need to review the formula.

[TMS]

Try:

Please Login or Register  to view this content.

[jeffreyESNW]

Try:

Please Login or Register  to view this content.

Absolutely huge thanks, that did the trick!!!

[TMS]

You're welcome. Thanks for the rep.