Dropdown entry seperator question for Excel XP?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Office XP (2002) with all service packs applied

I have created a spreadsheet with any number of columns. I have added the
dropdown feature (not sure of its exact name) on the column heading, so that
I can easily select all entries in that column that have a specific value. -
(A down Arrow has now appeared at the end of the column heading that I can
click on to do this).

Most of the column values are one entry e.g. FRED or JOE, so when I click on
the arrow I can select all of the FRED or JOE entries. Some of the column
values can be FRED and JOE however.

I want a way to be able to enter FRED and JOE in one column cell, but when I
click on the drop down, be able to select FRED and see all single FRED rows,
plus the one that contains FRED (even if it contains something else)

If I now look at the options from the Drop down Arrow, I have one for FRED,
one for JOE and one for FRED,JOE.

Is there a seperation character, that I can use to enable me to do this, I
have tried commas, colons etc.

Please can you help me?
 
Hi,

It sounds like you using autofilter so create a custom filter like this:-

Click the down arrow on you column a select custom.
In the dropdown select 'Begins with' and enter Joe
Click OR
In the other dropdown select 'Begins with' and enter Fred
Click Ok

Mike
 
Mike,
Thanks for the reply that was useful.
Problem is that what I also need to do is use the list that it shows on the
dropdown to also establish what the next entry should be.. e.g If cell 1
contains G1, cell 2 contains G2, cell 3 contains G3,G5 and cell 4 contains
G4,
I was hoping to use the dropdown list to easily identify that in the next
cell i needed to add G6. At present I cant easily see that,
I hope that that makes sense,
My list is huge, so its not easy to show you how many entries there are in
this explanation?
 
Back
Top