Surely this is possible but i am lost. I have tried a few different ways to accomplish this but run into the "Formula is too long" scenario. Here is what i am trying to do:
A1:A16 contains the data. I want to be able to compare each cell within the range to all of the other cells within the same range for a difference of<.630 . For example, compare A1 to A2--A16, A2 to A1--A16, and so on. If the difference is encountered then some sort of flag would be raised whether it be cell formatting or a return value of TRUE/FALSE to an adjacent cell. Any help appreciated.
Waxaholic
This message was edited by Waxaholic on 2002-04-11 13:28
A1:A16 contains the data. I want to be able to compare each cell within the range to all of the other cells within the same range for a difference of<.630 . For example, compare A1 to A2--A16, A2 to A1--A16, and so on. If the difference is encountered then some sort of flag would be raised whether it be cell formatting or a return value of TRUE/FALSE to an adjacent cell. Any help appreciated.
Waxaholic
This message was edited by Waxaholic on 2002-04-11 13:28