ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can this be done? (https://www.excelbanter.com/excel-discussion-misc-queries/102453-can-done.html)

Abbo

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




All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com