Combining Formulas

[Marhier]

Hey everyone.
After a bit of help.

I've got three formula, all of which work perfectly on their own, in separate cells.

=IFERROR(SORT(UNIQUE(FILTER(PurchaseOrderTable[Category],PurchaseOrderTable[Category]<>""))),"")

=IFERROR(SORT(UNIQUE(FILTER(SiteReqTable[Category],SiteReqTable[Category]<>""))),"")

=IFERROR(SORT(UNIQUE(FILTER(HireOrderTable[Item Category],HireOrderTable[Item Category]<>""))),"")

Is there a way I can combine all these formulas into one formula, which will give me one, sorted, unique list of results?

All support is greatly appreciated.
Thank you.
Regards,
Marhier.

 

[awoohaw]

It would be helpful if you could provide some sample data using the xl2bb add in (link below). If you cannot use that please post as a table, not an image.
Otherwise the each forum member that wants to help needs to recreate the data which is time consuming and can cause have errors in assumption of your data layout.

Thanks in advance.

 

[dreid1011]

Maybe a VSTACK:

=SORT(VSTACK(UNIQUE(FILTER(PurchaseOrderTable[Category], PurchaseOrderTable[Category]<>"")),UNIQUE(FILTER(SiteReqTable[Category],SiteReqTable[Category]<>"")),UNIQUE(FILTER(HireOrderTable[Item Category], HireOrderTable[Item Category]<>""))))

But this is just a guess, and as @awoohaw mentioned, additional information will be much more helpful.

 

[Marhier]

.

 

[Marhier]

.

 

[Marhier]

Maybe a VSTACK:

=SORT(VSTACK(UNIQUE(FILTER(PurchaseOrderTable[Category], PurchaseOrderTable[Category]<>"")),UNIQUE(FILTER(SiteReqTable[Category],SiteReqTable[Category]<>"")),UNIQUE(FILTER(HireOrderTable[Item Category], HireOrderTable[Item Category]<>""))))

But this is just a guess, and as @awoohaw mentioned, additional information will be much more helpful.

This worked.
Thank you!

 

[dreid1011]

This worked.
Thank you!

You're welcome, and happy to help.

 

[Marhier]

The only thing I had to add was a UNIQUE at the beginning to then make the final list remove any duplicates:

=IFERROR(SORT(UNIQUE(VSTACK(UNIQUE(FILTER(PurchaseOrderTable[Category],PurchaseOrderTable[Category]<>"")),UNIQUE(FILTER(SiteReqTable[Category],SiteReqTable[Category]<>"")),UNIQUE(FILTER(HireOrderTable[Item Category],HireOrderTable[Item Category]<>""))))),"")

I can't thank you enough.
Have a great day, everyone.