Based on the most recent sample file, change the formula in F2 and copy down
until you get blanks:

=IF(ROWS(F$2:F2)<=COUNT(A$2:A$5),SMALL(A$2:A$5,ROW S(F$2:F2)),"")

--
Biff
Microsoft Excel MVP


"zoomzoom632" wrote in message
...
I need to make another change, I did end up figuring out how to get more
date, but when a cell (in the number column) is blank it acts as though it
were zero, it there a way to avoid this? If so, how?

Thanks and sorry.

"zoomzoom632" wrote:

Biff,

The equation works weel, but it there anyway to get it to observe more
information, because this is allowing me to look at the top four
numbers/time
on the list, I would like to be able to look at 50-60 different numbers,
I've
tried various things, but I cant figure out the propper numbers to
change.

Thanks.

"T. Valko" wrote:

I apologize if I am taking up too much of your time.

Nah, don't worry about it. THIS is what I do with my time!

Ok, see this sample file. This is what you wanted to do from your
description in your very first post. The formula in column G is an
array
formula. Array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER).

http://cjoint.com/?kpfOViFyIX

--
Biff
Microsoft Excel MVP


"zoomzoom632" wrote in message
...
Biff,

That's pretty much what I mean, but is there anyway to continue that
down
the list?When I entered "5" in F2, I couldn't enter 1 in F% to get
those
names, is there a way to do that?

Also, I apologize if I am taking up too much of your time.

"T. Valko" wrote:

It's still not clear (to me!) what you want to do.

Based on the first post of this thread it sounds to me like you're
just
duplicating you data but in a different order. That's why I
suggested
just
sorting it or making a copy and sorting that copy.

If you have duplicate numbers and you want to do a lookup based on a
number
it can be complicated. I assume if you enter the number 1 then you
want
all
the info for *every instance* of 1:

6...Bob...Ohio
1...Joe...California
1...Sam...New York
7...Sue...Georgia.

See if this sample file is what you had in mind:

DeleteMe.xls 16kb

http://cjoint.com/?knxBzcL3yL

Select a number from the drop down and the list populates based on
that
selection.

The formulas used to do this are array formulas. Array formulas need
to
be
entered using the key combination of CTRL,SHIFT,ENTER (not just
ENTER).

--
Biff
Microsoft Excel MVP


"zoomzoom632" wrote in
message
...
Yeah, that's basically what I mean, but I forgot to include
something
in
my
previous message. The list is in alphabetical order by the name.
so
your
list would be...

6...Bob...Ohio
1...Joe...California
1...Sam...New York
7...Sue...Georgia.

Also, please disreguard my message, "Number Order"

Thanks and sorry.

"T. Valko" wrote:

Now, there's a curve ball, Sheet one has the numbers repeating.

Do you mean that there are different names with the same number?

1...Joe...California
7...Sue...Georgia
6...Bob...Ohio
1...Sam...New York

Column 1: I want to be able to enter a number.

So, if you enter number 1 which line of info do you want?

--
Biff
Microsoft Excel MVP


"zoomzoom632" wrote in
message
...
There is a slight change here.

Sheet One lists:
Column 1: A number
Column 2: A person's Name
Column 3: The place they are from.

On Sheet two,
Column 1: I want to be able to enter a number.
Column 2: Based on the number in column 1, sheet 2 that I
entered,
the
person's name that is next to that number on sheet one will
apear.
Column 3: Based on the number in column 1, sheet 2 that I
entered,
the
place
they are from, that is next to that number on sheet one will
apear.

Now, there's a curve ball, Sheet one has the numbers repeating.
So
I
want
to makesure the correct number matches the correct name, then
I'll
base
the
place they are from off of the name which can only appear once
in
the
list.

Thanks to several responces, I managed to create the page
worksheet
to
interact like I listed below.

"zoomzoom632" wrote:

Here's the Senario,

Sheet One Contain the Results of a Race:
Column A: Racers Name (in ABC order)
Column B: Their Hometown
Column C: Their Time
Column D: Their Heat Number

On Sheet 2 I want to have the spreadsheet seach for the proper
infomation
from sheet 1.
The Colums are the same, and here, the row numbers represent
the
place
number.

In Column C, I want it to find the lowest time first, then in
the
2nd
row,
find the 2nd lowest time, ect.

In the other three column, I want it to match the data listed
next
to
the
time from sheet one, in their appropriate columns.

I hope you can figure out what I mean.

Thank you.