Re: Compare two columns and display value in 3 cloumn

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

are you looking for sth like this:

=IF(COUNTIF($A$1:$A$100,B1)>0,B1,"")



On 12 Gru, 17:19, Raj <R...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi
I have data in Excel Sheet in the following way

A         B        C
123    234  
1        2
2      123

The data in Column B have to compare the value in Colmun A and if found the
value have to be displayed in Column c
Can you please me regarding htis issue.

.

Relevant Pages

  • Compare two columns and display value in 3 cloumn
    ... I have data in Excel Sheet in the following way ... The data in Column B have to compare the value in Colmun A and if found the ... Can you please me regarding htis issue. ...
    (microsoft.public.excel.misc)
  • Re: Is this doable using excel?
    ... > Say I have this in an excel sheet: ... > I want to compare each cell of one row to another cell in same ... > I want to compare top A with bottom A, top B with bottom B, and so ...
    (microsoft.public.excel.programming)
  • Re: A question about table alias and "group by"
    ... (select sth from B2 group by sth) ... And B2.condtions compare with B3.conditions ... how drill infomation from B2? ... Sybrand Bakker ...
    (comp.databases.oracle.server)
  • Re: Is this a Query
    ... Hello, i have a suggestion, what about linking the Excel Sheet to Access?, ... then u can make a query in order to compare.. ... > I have the same information in an Excel spreadsheet that I ...
    (microsoft.public.access.queries)
  • RE: Compare two columns and display value in 3 cloumn
    ... "Raj" wrote: ... I have data in Excel Sheet in the following way ... The data in Column B have to compare the value in Colmun A and if found the ...
    (microsoft.public.excel.misc)