The easiest way to do this is in two steps:

1. Separate your data into cells by using Text to Columns
2. Get the two largest numbers using the Large function.

Post back if you need more help on either. Also tell us what version of
Excel you are using.

Regards,
Fred.

"mpenkala" wrote in message
...
Hey,

I have a column of cells that contain either 1,2,3 or 4 numbers listed as
so:

1
1,3
1,3,8
4,5,6,7

What I want is for a cell to look at the numbers and give me the 2 largest
numbers. If there is only 1 number, then it can return just that one
number.


Thanks.
matt