View Single Post
  #37   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Maddening Dilemma - Compare each cell within column a to each cell

Going by your latest explanation to Pete
for your earlier line
.. round it off to the tenths place


think the line:
Just amend the 2 in ROUND(..,2) to ROUND(..,10)


should have read as:
Just amend the 2 in ROUND(..,2) to ROUND(..,1)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---