Forum Discussion
Filtering Columns of Data (Named Ranges) based on Brand Names
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?
Attached in this document are the examples for what I want based on the document that I attached previously...
But please keep in mind, this is only a gist of the real project, the real data that I have to deal with has a lot more columns...
Peter