Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting examples from a table
Suppose I have a 2-column table. Column A contains the names countries and
column B contains the name of a city in that country. The same country can appear more than once in column A, but the whole table is unsorted. (So the first 5 cells in column A might read England, France, Germany, France, Germany and in column B Liverpool, Paris, Munich, Marseilles, Berlin). I want to extract from this table a smaller table with each country appearing once in the first column and the second column containing any relevant example city in that country. Is there a simple way to do that? I tried using a pivot table with the "MIN" function, hoping that MIN would pick the alphabetically first city, but "MIN" only works on numbers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Fields in Pivot Table | Excel Discussion (Misc queries) | |||
formula for selecting cells in one table from values in another | Excel Worksheet Functions | |||
'if' formula selecting a cell from a table | Excel Worksheet Functions | |||
Selecting Specific Data within a Table | Excel Worksheet Functions | |||
Selecting valuse from a table | Excel Discussion (Misc queries) |