HI,
One of the alternative is:
*=ROUND(C3,-1)*
110 110 110.5 110 111 110 111.5 110 112 110 112.5 110 113 110 113.5 110 114
110 114.5 110 115 120 115.5 120 116 120 116.5 120 117 120 117.5 120 118 120
118.5 120 119 120 119.5 120 120 120
On Fri, Sep 24, 2010 at 10:55 AM, Srinivasan Ethirajalu <
sri
please find the excel with result of 3 column comparision:
i have checked for isblank formula & assigned with weightage as 1,2,4 for
col a,b,c
On Fri, Sep 24, 2010 at 10:40 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Please clarify:
> Below are all possibilities:
>
> *
Please clarify:
Below are all possibilities:
***
Possibilities: Value to be displayed
***
ABC 1
A-- 2
-B- 3
--C 4
AB- 5
A-C 6
-BC 7
-
Hello I have 3 columns with data and I need to make the following
comparisons:
1. value exists in all three columns
2. value exists in ONLY the first column
3. value exists in ONLY the second column
4. value exists in ONLY the third column
5. value exists in column 1 and exists in only column
