Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
References...
I have one column with names and nationalities, the latter as an abbreviation
such as (USA) In a separate list I have to sum the different nationalities. Somewhat like this. Col. A Miller (USA) Forget (FRA) Smith (GBR Schmidt (GER) Stone (USA) Meier (GER) ¦ (The names in this col. A may be typed in the cells or come from a formula) The List in say, col. Q and R, should the look like this: France 1 Germany 2 Great Britain 1 USA 2 .... The column in Q with the country names exists already and the two columns (Q:R) should be able to be sorted. Is there a formula (or macro) that can do the trick? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) |