| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace a derived value with a label
I need to have the maximum value in a column replaced with it's ocncordant
label. For example in the following table I need to see Alberta rather than the MAX value underneath the Jan Column: Sales by Region Jan Feb Mar Apr May BC 45600 50000 48000 52600 54700 Manitoba 45600 44000 48000 48000 46500 Ontario 45650 49000 56000 64500 58700 Saskatchewan 45900 45000 45600 44100 38900 Alberta 55700 48000 51000 54500 54600 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup derived wrong value | Excel Worksheet Functions | |||
| How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
| functions derived from cell contents | Excel Worksheet Functions | |||
| i need a number total derived from words | Excel Worksheet Functions | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
