Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AutoFilter
Hi all,
When using AutoFilter to match a name in column "A" to a number in column "B", can one add more names and corresponding numbers to the existing lists? If so how is this accomplished. Thanks, Ken |
#2
|
|||
|
|||
Hi Ken
sorry, don't quite understand how you're using AutoFilter to match a name in column A to a number in column B to start with ... if you'ld like to explain what you're trying to achieve then we might be able to come up with a useable solution - one option that comes to mind is the VLOOKUP function but i'll need more details. Cheers JulieD "Ken" wrote in message k.net... Hi all, When using AutoFilter to match a name in column "A" to a number in column "B", can one add more names and corresponding numbers to the existing lists? If so how is this accomplished. Thanks, Ken |
#3
|
|||
|
|||
Julie,
If you will, please check my post of 03/17/2005 "Finding a Match". I think this will explain. The answer I received works great on my existing data but I'm wondering if I can add to my lists and if so.. how? Thank you very much. Ken "Ken" wrote in message k.net... Hi all, When using AutoFilter to match a name in column "A" to a number in column "B", can one add more names and corresponding numbers to the existing lists? If so how is this accomplished. Thanks, Ken |
#4
|
|||
|
|||
Hi Ken
unfortunately i can see your reply posts of 18th and 19th, but not the solution that was offered to you - the one you have currently working - if you can repost that i'll take a look at it. Cheers JulieD "Ken" wrote in message nk.net... Julie, If you will, please check my post of 03/17/2005 "Finding a Match". I think this will explain. The answer I received works great on my existing data but I'm wondering if I can add to my lists and if so.. how? Thank you very much. Ken "Ken" wrote in message k.net... Hi all, When using AutoFilter to match a name in column "A" to a number in column "B", can one add more names and corresponding numbers to the existing lists? If so how is this accomplished. Thanks, Ken |
#5
|
|||
|
|||
"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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
EXCEL AUTOFILTER | Excel Worksheet Functions |