Hi,
I have a row of values as follows with maximum upto 10 values in eac
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 remainin
values
I am relatively new to excel. I am not sure how to get it to work.
want the final number to be calculated automatically whenever th
numbers in any of the cells change.
I appreciate all your help.
Thank you.
Yusu
--
Message posted from
http://www.ExcelForum.com