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
"Rich" wrote:

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?

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?




"Mike H" wrote:

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
"Rich" wrote:

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?