Maybe it could be as simple as
=max(a:a:) on row 2 and copy to the right. Then transpose row 1 & 2

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
hi,

Have a question, the function of Hlookup.

Below are the details in the sheet.

DataSheet
date - Feb1,2005 Feb2,2005 Feb3, 2005
item id
1 100 200 100
2 150 100 250
3 490 500 900
4 90 10 20


Output
item Max Date
1 200 Feb2, 2005
2 250 Feb3, 2005
3 900 Feb3, 2005
4 90 Feb1, 2005

How do I get the above output from DataSheet.
Require urgent help.

Captain