Filter: Multiple values in a cell

P

pandora

Sorry if this was covered here before - spent long time searching...

I'm trying to use excel as a database ;)
I have a very long Excel table that lists the features in th
application.

Easy part: I need to keep an information about the customer wh
requested this particular feature and to be able to sort the list o
features by the customer name.
So the easiest way will be to add a column with the customer name in i
and auto-filter by this column.

Hard part: one feature can be requested by multiple customers. S
somehow I need to put multiple customer names into one cell and stil
be able to filter.

Eben harder: I need to have also the version column (and if thi
feature was implemented in two different versions - again - I shoul
havea multiple values in this cell and be able to filter.

Any suggestions?

Thanks
~
 
J

Jeff Stevens

Add another column and use the CONCATENATE function to combine as many
columns as you need and then sort and/or filter based on that new column.
 
Top