| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning column header as result
I have a mileage table exported out of Map Point and into Excel. I have a
formula to return the minimum mileage but I also need to return the city in the column next to the formula. I'd also like to find the next closest city. Any help will be appreciated. Min Formula - =MIN(AI2:CY2) Columns look like: Closest Min Dist Amusement Chicago Cincinnati Cleveland Springfield 2 Field Museum 2 200 400 150 xx Six Flags, Gurney xx xxx xxx xxx xxx Six Flags, St. Louis xx xxx xxx xxx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Summing a column, result coming up 0 | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Threaded Mode
