Changing Formula to be compatible with older versions of Excel

[Jbest23]

Hi, I have a spreadsheet that is currently working for Excel 2021 and up. This spreadsheet allows individuals to make a QTY input on one sheet to output a particular SKU (item) with that chosen QTY on another. Additionally, the outputs are filtered and sorted automatically. The following formula is used to accomplish this:

=IFERROR(SORT(HSTACK(FILTER(ProductSelection!G11:H3000,(ProductSelection!K11:K3000>0)),FILTER(ProductSelection!J11:K3000,(ProductSelection!K11:K3000>0)),FILTER(ProductSelection!I11:I3000,(ProductSelection!K11:K3000>0)),FILTER(ProductSelection!L11:M3000,(ProductSelection!K11:K3000>0))),1,1),"")

The issue arises when I send this spreadsheet out to others. Multiple people receiving this spreadsheet have excel versions as old as 2010. Is there a way to modify this formula to be compatible with older versions while keeping the same functionality more or less? Thank you!

 

[Jbest23]

As an update for those who might not know, the SORT, HSTACK and FILTER functions are not available for Excel versions older than 2021.