Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello all,
I'm having a bit of a problem that I hope that someone can help me with. Here's my sample data range: City, Rate Chicago, 50 New York, 23 San Francisco, 43 San Jose, 55 Baltimore, 14 Ann Arbor, 28 I want to populate a two-column, five row table with the city and rate. I've used the SMALL function in the rate column to include the five lowest rates. My problem is, I'm able to retrieve the rates, but I can't populate the first column with the City. What I need is if column B=14, then A=Baltimore and such. Does anyone have any ideas how I can set that up? Holli - who hopes that was semi-coherent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Having Trouble with the RANK Function...Try LARGE or SMALL Functio | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |