Forum Discussion
Solved
Filtering Columns of Data (Named Ranges) based on Brand Names
Hi Everyone, I am trying to filter columns of data (named ranges) that are on same Excel spreadsheet based on brand names... I want the results of what have been filtered on a different spreadsheet....
See Sheet2 in the attached version. If it is not what you want, please explain.
Sorry!! I forgot to delete the old Named Ranges and make new ones... Please see the new file..
Peter
Thanks, the names are valid now. Can you explain what and how you want to filter?
I would like all information in the Excel file to remain in the same cells that they are on the first spreadsheet, but at the same time, I want the same information categorized by brandnames on a second spreadsheet (one column for each category)...
Does anyone know the formula(s) for this?
Peter
Can you provide a few examples of the desired output?