Forum Discussion

paejunk's avatar
paejunk
Copper Contributor
Nov 01, 2024

FILTER Function - "include" parameter as string from another cell

Hi All   I have a table on Worksheet A, unimaginatively named "Table1", with fields including "CODE". On Worksheet B, in cell C1, I have this formula: =FILTER(Table1,(Table1[CODE]="T1") + (Tabl...
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Nov 01, 2024

paejunk 

The first thing that comes to mind is using the filter dropdown in Table1; the second is using slicers instead.

paejunk's avatar
paejunk
Copper Contributor
Nov 01, 2024

Detlef_Lewin thanks for the reply. 

I know how to use the drop-downs and I have even previously written VBA to do the filtering (in a different scenario).

 

To be honest I've no idea what a slicer is - that's for another day I think.


I just thought that I'd try the FILTER function, which presents just the extracted records - which is a neat idea (particularly if I can get it to only bring through certain columns).  The problem is how to get a string, held in a cell, to be the 'include' parameter.  I wouldn't have thought it could be hard but I've been scratching my head for some time on this. 🙂

Thanks for your time, all the same - much appreciated.


Resources