| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
display Column Header based on cell value in a range
So I have been looking and have failed. I am trying to divise a function that will find the smallest values in a range (distantce in miles) for a given employee and output the store number (column header) which is closest to that employee and inversely the employee that has the smallest distance to a given store. I need to do this for the 3 smallest values. I have attached a sample of the sheet in which i am working with. Thanks for looking
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Dates in a range based on Column Header Id without using sum-product | Excel Worksheet Functions | |||
| How to display month in a column based on a value in a cell | New Users to Excel | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Row & Column Header Display | Excel Discussion (Misc queries) | |||
| Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
Threaded Mode
