you're welcome ...
"Ken" wrote in message
k.net...
Julie,
Thank you for the information. I was not aware of the 1000 limit. I'll
just use more worksheets when I reach the 1000.
Again, thank you for your time and knowledge.
Ken
"JulieD" wrote in message
...
Hi Ken
adding 500 rows to the existing data will not affect the autofilter in
any way so just tack them on the end (don't leave a blank row or
anything) ... however, just a note, that the drop down box of the
autofilter will only show the first 1000 unique entries in the column
Cheers
JulieD
"Ken" wrote in message
k.net...
Actually I want to add the 500 rows to the existing data. But I'm glad
you provided this info. I'm sure it will come in handy.
Thanks, Ken
"JulieD" wrote in message
...
Hi Ken
okay ... now i need to know what you mean by "add to your lists" ... do
you mean add another 500 rows to the existing data or do you mean,
you've got the info for Donald Getts and you also want to see the info
for Fred Bloggs without hiding Donald Gett's info - if so
use the drop down arrow and choose CUSTOM
in the first drop down box choose
equals
choose
Donald Getts
select "OR"
choose
equals
the in the last drop down box choose Fred Bloggs
... you'll see the records for both people.
if you want more than two you'll need to use the advance filters
instead of autofilters.
is this what you're after?
Cheers
JulieD
"Ken" wrote in message
nk.net...
"Ken" wrote:
Hi,
I have two columns 300+ rows long. One (A) contains names. One (B)
contains single digit numbers; either 1 or 2 or 3, etc. through
number 8.
What I would like to do is type in a name in, lets say (C10) that
would return EVERY number in column (B) that was next to that name.
If I type in(C10) Donald Getts and this name appears 20 times in (A)
I need the 20 numbers that are in column (B) next to Donald Getts.
Of course I need the numbers separated by a comma or have them appear
in separate cells would be better yet.
Sorry to drabble on but I see so many questions here that are harder
to decipher than the answers provided.
Thank you, Ken Williams
(RESPONSE)
Julie, The suggestion below works fine for the existing data but I
would like to add to the lists.
Ken
Use the AutoFilter functionality
Make sure you have a column heading for each of the two columns
With any cell in your 'database' active, select Data | Filter |
Autofilter
from the menu. This will add little drop down arrows next to each
column
heading.
Click on the drop down arrow for the names and select Donald Getts
from the
list. Excel will filter the table to show every occurrence of his
name, and
the associatiated numbers. Just highlight & copy/paste the numbers to
a new
location
|