Creating linked tables in different worksheets with only certain columns selected.

[leojez]

Hello! Hoping someone can help with this head scratcher!

I've got a workbook with various worksheets in, and a dashboard worksheet where I'm putting key info from other worksheets.

I've got one section of a table working perfectly using the following:

=TableWatchList[[#All],[Ticker]:[Change (%)]]

However, I want to do the same with another table, but only for certain columns (not a range, as in the first table). I can't seem to get a working formula, basically, I want the following:

Table name:
Assigned_Stock_Table

Columns to show:
Ticker
Current price
Assigned price
Current Profit / Loss

I've tried variations, such as

=Assigned_Stock_Table[[#All],[Ticker],[Current price],[Assigned price],[Current Profit / Loss]]

but whatever I attempt doesn't work. Any ideas on this?

Thanks!

 

[Fluff]

How about like

=FILTER(Assigned_Stock_Table[#All],(Assigned_Stock_Table[#Headers]="Ticker")+(Assigned_Stock_Table[#Headers]="Current price")+(Assigned_Stock_Table[#Headers]="Assigned price"))

 

[leojez]

Amazing! Thank you very much!!

 

[Fluff]

You're welcome & thanks for the feedback.