If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help: Compare two columns
I have two coloumns of numbers, which i need to compare. The Excel document
should come out with 3310 as a result in coloumn 3. Can someone help me? example: Coloumn 1 2211 5510 2210 9952 Coloumn 2 2211 5510 3310 2210 9952 |
#2
|
|||
|
|||
Compare two columns
Hi there,
in cell C1 you could type the following formulae: =IF(ISNA(MATCH(B1,A:A,0)),"",B1) and then drag this formulae down to other cells. You could then copy and paste the values from column C elsewhere, sort it to remove the blanks, and there's your list of numbers that appear in Column B but not in Column A. HTH, Katherine "CHR" wrote in message news:01c39e07$8ea0fa20$8b1f12ac@pc5851... I have two coloumns of numbers, which i need to compare. The Excel document should come out with 3310 as a result in coloumn 3. Can someone help me? example: Coloumn 1 2211 5510 2210 9952 Coloumn 2 2211 5510 3310 2210 9952 |
Thread Tools | |
Display Modes | |
|
|