Assume your numbers are sort in ascending order\
then try this:

=RIGHT(A1,3)
copy down


"mpenkala" wrote:

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