Currently have a formula that works, but as it checks over 200k rows in a table, it takes 10+ seconds to run all the formulas on the sheet it's contained in (sheet it's contained has about 2k rows itself). Not sure if there is a more efficient way to write this formula, or maybe I should be using a custom function, but please let me know if there is something I can do to speed up the formula calculations on the sheet, thanks.
Code below, need to pull every "Vendor" value from that VendorFiles table where the identifier in the VendorFiles table matches the identifier value from the sheet the formula is on.
Code below, need to pull every "Vendor" value from that VendorFiles table where the identifier in the VendorFiles table matches the identifier value from the sheet the formula is on.
Excel Formula:
=IFERROR(TEXTJOIN(", ",TRUE,FILTER(VendorFiles[Vendor],VendorFiles[identifier]=[@[identifier]])),"")
