View Single Post
  #35   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pogster@gmail.com is offline
external usenet poster
 
Posts: 41
Default Maddening Dilemma - Compare each cell within column a to each cell

Pete,

Also, as in max's example, is there a way for the macro to round the
numbers it looks for to the TENTHS (thats one decimal place) place?
As in, a value of 1001.19 is simply rounded off at 1001.1. Not like
rounding up or down, but just ignoring the hundreths place all-
together. I posted my reasoning to Max for this, so you can see up
top for a description.

If this is too difficult, forget it, but it would help!

Thanks again.

-pogster