If you don't have duplicate values in the range, you could use something like:
=--(MAX(A1:E1)&"."&SUBSTITUTE(A1&B1&C1&D1&E1,MAX(A1:E 1),""))
(you'll have to add your other columns into both sections of this formula).

Remember that excel has a limit of 15 significant digits. (type
123456789012345678 in a cell and you'll see what excel does (format it as
number, 0 decimal places).)

If you can return text:
=MAX(A1:E1)&"."&SUBSTITUTE(A1&B1&C1&D1&E1,MAX(A1:E 1),"")

With: 12 34 21 17 90 in A1:E1, I got:
90.12342117

as my result.




"yaghani <" wrote:

Hi,

I have a row of values as follows with maximum upto 10 values in each
row:

<--- 5 values --- some other colummns <--- 5 values ---
12 34 21 17 90 76 6
51 33 21 21 34

I would like to compute a number out of these values as follows:
1. integer part of the number is maximum of all the values in a row
2. decimal part of the number is concatenation of all the remaining
values

I am relatively new to excel. I am not sure how to get it to work. I
want the final number to be calculated automatically whenever the
numbers in any of the cells change.

I appreciate all your help.

Thank you.

Yusuf

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson