If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a list from an existing list
hi!
is there a formula that can create a list from an existing list for some specific creteria. so kind of an iteration. so say in one sheet i have list with colums Name, Address, Phone no. Now i would like to pull out certain records(just Names, not other columns)in another worksheet. AutoFilter wont work as i have too many blank rows in the list i know this was posted earlier and m not sure if anyone responded. |
#2
|
|||
|
|||
creating a list from an existing list
Hi
try using 'Advanced filters' and choose the other worksheet as target range -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... hi! is there a formula that can create a list from an existing list for some specific creteria. so kind of an iteration. so say in one sheet i have list with colums Name, Address, Phone no. Now i would like to pull out certain records(just Names, not other columns)in another worksheet. AutoFilter wont work as i have too many blank rows in the list i know this was posted earlier and m not sure if anyone responded. |
#3
|
|||
|
|||
creating a list from an existing list
"Frank Kabel" wrote...
try using 'Advanced filters' and choose the other worksheet as target range ... Note: copying advanced filter results to other worksheets requires making the destination worksheet active then running Data Filter Advanced Filter because Excel will only return data to the active worksheet. Make this a bit convoluted. -- To top-post is human, to bottom-post and snip is sublime. |
#4
|
|||
|
|||
creating a list from an existing list
Note: copying advanced filter results to other worksheets requires making the destination worksheet active then running Data Filter Advanced Filter because Excel will only return data to the active worksheet. Make this a bit convoluted. Hi Harlan thanks for the addition. I'm alread so used to this 'feature' I forgot to mention it Frank |
#5
|
|||
|
|||
creating a list from an existing list
thanks for the reply. but i dont know why it's not working.
i ve a column of ph. no. and my criteria is all #'s with area code 905. so i am entering 905*. but it hides the complete list. am i missing something here. thanks again -----Original Message----- Note: copying advanced filter results to other worksheets requires making the destination worksheet active then running Data Filter Advanced Filter because Excel will only return data to the active worksheet. Make this a bit convoluted. Hi Harlan thanks for the addition. I'm alread so used to this 'feature' I forgot to mention it Frank . |
Thread Tools | |
Display Modes | |
|
|