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:
>
> ***************************************
> Possibilities:   Value to be displayed
> ***************************************
> ABC              1
> A--              2
> -B-              3
> --C              4
> AB-              5
> A-C              6
> -BC              7
> ---              8
> ***************************************
>
> On Thu, Sep 23, 2010 at 11:14 PM, OS <osf...@gmail.com> wrote:
>
>> 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 2 or 3 but does
>> NOT exist in BOTH 2 and 3
>> 6.  value exists in column 1 but NOT in column 2
>> 7.  value exists in column 1 but NOT in column 3
>> 8.  value exists in column 2 OR column 3 but not in column 1
>>
>> thank you in advance (I know it is a lot of parameters)
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Srinivasan Ethirajalu,
> +919840544295
>



-- 
Srinivasan Ethirajalu,
+919840544295

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Attachment: 3column comparision.xls
Description: MS-Excel spreadsheet

Reply via email to