View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abbo Abbo is offline
external usenet poster
 
Posts: 9
Default can this be done?

hi all
basically i want to have a tolerance for a value in column D depending on an
entry(model size) in column A.
if its over or under this tolerance the entry would be highlighted .
for each model size these would be subtotaled.
then i would like a function that would compares column B values of the
highlighted values if they are the same it would give me a value of 1, if
there were 2 different values it would give me 2 etc. anybody have an
idea
how to do this i would really appreciate it
thanks
if you need more info please dont heatiate to contact me thanks