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)
sintx Perhaps your Excel version already supports the new FILTER function. It spills the subset from a larger table based on criteria set in the formula. Basically the same as the filtering, copying, pasteing that you do now, but it's all dynamic and will update automatically with the larger 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)
sintx Please clarify. Don't really understand either of your questions.