LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Referencing data using the SMALL function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
Having Trouble with the RANK Function...Try LARGE or SMALL Functio Jadie56 Excel Worksheet Functions 0 August 16th 06 06:55 AM
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"