Re: Filter: Multiple values in a cell

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.


"pandora" <pandora.1zldqy_1133828101.3532@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:pandora.1zldqy_1133828101.3532@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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 the
> application.
>
> Easy part: I need to keep an information about the customer who
> requested this particular feature and to be able to sort the list of
> features by the customer name.
> So the easiest way will be to add a column with the customer name in it
> and auto-filter by this column.
>
> Hard part: one feature can be requested by multiple customers. So
> somehow I need to put multiple customer names into one cell and still
> be able to filter.
>
> Eben harder: I need to have also the version column (and if this
> feature was implemented in two different versions - again - I should
> havea multiple values in this cell and be able to filter.
>
> Any suggestions?
>
> Thanks
> ~p
>
>
> --
> pandora
> ------------------------------------------------------------------------
> pandora's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=29381
> View this thread: http://www.excelforum.com/showthread.php?threadid=490931
>


.

Relevant Pages

  • Re: School teacher needs help! Need to filter all columns, not just o
    ... When you apply AutoFilter feature to your table, ... When you apply Advanced Filter feature, ... When you want to sort your table, ... this named range as source table for ODBC query. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: DataView on two DataTables
    ... the Parent (Customer) table? ... Suppose you want to show OrderHeader fields but also ... you should be able to filter and sort using the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: max of sum
    ... "order by 2 desc" means sort the output of the 2nd column in the SELECT ... See the Access Help article on the TOP predicate for more info. ... > i need to filter out the customer who bought most tickets in an access db. ...
    (microsoft.public.access.queries)
  • Re: So long Raining Data. Hello TigerLogic Corporation.
    ... MARKET under that term is where the point was being made. ... only customer base, the only community from which my company currently ... We have to take that feature all the way from ...
    (comp.databases.pick)
  • Re: Sharepoint vs. Livelink
    ... Both Sharepoint and Livelink ... Is your customer a Windows shop? ... The idea is to make a functional non-technical feature set that the ...
    (comp.doc.management)