Forum Discussion
Extract a subset of a table in another sheet (and keep the link to the master table)
Thank you very much, Indeed the Filter function is working well.
It does seem to require that the Filter rule needs to be related to a cell reference. ( cannot be a text entered directly)
An additional question is with reference to the below formula, I now have multiple filter formula's to extract the specific column or consecutive columns. Is there a way to either have a listing of desired columns in the array or a formula that builds the filter function, making it dynamic?
=FILTER('Master Import'!$B$2:$B$9456,'Master Import'!$F$2:$F$9456=$B$2)
Thank you very much, Indeed the Filter function is working well.
It does seem to require that the Filter rule needs to be related to a cell reference. ( cannot be a text entered directly)
An additional question is with reference to the below formula, I now have multiple filter formula's to extract the specific column or consecutive columns. Is there a way to either have a listing of desired columns in the array or a formula that builds the filter function, making it dynamic?
=FILTER('Master Import'!$B$2:$B$9456,'Master Import'!$F$2:$F$9456=$B$2)
sintx Please clarify. Don't really understand either of your questions.