Concatenate Table Sort Error

[nschneemann]

Concatenate Table Sort Error:

I am concatenating several values for use as a price lookup to a bloomberg code. The values are all in a excel 2007 table. When I sort the concatenate is not longer considering the values in its original recrord, thus looking up the incorrect price. The table includes totals and the totals change as you sort. Sorting by Table Column "ID" (record ID) realigns the concatenation and provides the original Total. Other individuals use this spreadsheet and I need it to be able to sort. Attached is the problem recreated in a watered down version of the spread sheet. Please let me know if you need more information.

Thanks,


Within Tables when you're concatenating values, you must use the reference syntax of the table, else you will encounter this problem. Replacing the cell referrences with TradeLog_Active[[#This Row],[BBG Code]], etc solved the issue.