View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patricia
 
Posts: n/a
Default 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