Hi everyone,
I'm trying to build a specification sheet of a single product in my excel-database.
For this I have a database with rows filled with 0's and 1's, the first row has the names of the functions each product has, or hasn't.
Now on another worksheet I want to summarize all functions the product has. I know I can hide products with a 0 (with IF), but then it leaves a blank space, wich looks ugly. Is there an easy option with formulas or another method to summarize the functions in a clean, organised way?
I've included a screenshot to make my explanation more clear.
The formula I use now just shows the Title of the column when 1, and " " when it's 0.
Thanks alot for your help, and greetings.
EDIT: in the screenshot I use green and red markers to visualize the 0's and 1's.
Bookmarks