Hi
I want excel to find the highest number in a column, Which i have done, but
i want it to display the name in the column to its left instead of the
highest number
--
thanks

try this sub assuming your data is in D3 to D13


Public Sub test()
Range("a1").Activate
Dim value As Single
value = WorksheetFunction.Max(Range("d3:d13"))

Cells.Find(what:=value).Activate
ActiveCell.Offset(0, -1) = ActiveCell

End Sub

perhaps better solutions may be forthcoming

Mike wrote in message
...
Hi
I want excel to find the highest number in a column, Which i have done,
but
i want it to display the name in the column to its left instead of the
highest number
--
thanks

Assuming the col with the numbers is col B,
with the names in col A, one col to the left

Put in say, C1:
=OFFSET($B$1,MATCH(MAX(B:B),B:B,0)-1,-1)

C1 will return the name with the highest number in col B

(It's also assumed that there won't be duplicate
highest numbers in col B)

Adapt to suit

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Mike wrote in message
...
Hi
I want excel to find the highest number in a column, Which i have done,
but
i want it to display the name in the column to its left instead of the
highest number
--
thanks

If if if if if you can be sure there is only ONE value equal to the max,
then with your values in Col B and required data in Col A

=INDEX(A1:A30,MATCH(MAX(B1:B30),B1:B30,0))

If more than one match possible then take a look at Aladin's post he-

http://tinyurl.com/64mz3

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Mike" wrote in message
...
I want to find the highest number in a column and display the name in the
column to the left of the highest number

--
thanks Mike



--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Mike" wrote in message
...
Hi
I want excel to find the highest number in a column, Which i have done,
but
i want it to display the name in the column to its left instead of the
highest number
--
thanks