Copy entries in list based on a cell content

Closed
galano - Jan 3, 2012 at 11:40 PM
 Blocked Profile - Jan 4, 2012 at 02:28 AM
Hello,

in sheet1 i have a list of names in column b and cities in column c..now in sheet2, after entering the city in cell B1, i would like to copy all the names from sheet1 column b that belong to that city i entered in cell A1...the list will start in cell B2 in sheet2 and fills downward until all the names are copied.....i just dont know how to make the table below,,,the columns just collapse and the names and cities get messed up..

Sheet1
A B C
1 -Names -Cities
2 -Theodore Solang -Baguio
3 -May Brooks -Iligan
4 -George Morgan -Tabuk
5 -Anne Filar -Baguio
6 -Mercy Boonar -Baguio
7 -Sherwin Mangi -CDO
8 -Cecile Forn -Tabuk
9 -Andrea Beker -Iligan
10 -Joseph Tayam -CDO
11 -Ferdie Gos -CDO

Sheet2. Enter name of City in B1 and all the names in that city will be displayed below it.
A B C
1 Enter Name of City: -Baguio
2 -Theodore Solang
3 -Anne Filar
4 -Mercy Boonar
5
6
7
8
9
10
11



Related:

1 response

Blocked Profile
Jan 4, 2012 at 02:28 AM
Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0