Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |