View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Matt Dunbar[_2_] Matt Dunbar[_2_] is offline
external usenet poster
 
Posts: 1
Default GCD & LCM: ANALYSIS TOOLPAK

BTW

i know that for 2 numbers the following works which is great

=MAX(A1:A2)*LEFT(TEXT(MIN(A1:A2)/MAX(A1:A2),"000000000000000/000000000000000"),15)

but i have to cope with 2 or 3 or 4 numbers also

mat

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