Forum Discussion
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...
Just curiosity, what option did you choose in the end?
(FYI there's a way to mark solutions, something that helps those who Search)
Hi Lorenzo
I was bowled over with the massive support and help I received. I'm still going through it - clearly there are new functions that I need to get to grasp with - and all very interesting. Once I've chosen a best route, I'll be sure to let you know. Thanks very much.
Peter