i need to compare two columns of numbers in two different workbook and display the whole row if results are equall. is excell capable in doing this without programing(source code)?

Yes. It is. Tom

This is the formula you will need to compare results between worksheets. Type this in the cell you want the results to be displayed. The same will apply with worksheets. Open both worksheets Click in the cell where you want the result to be displayed and type =IF( next click in the cell you wish to compare in this workbook and it should appear automatically in the formula edit section. Next type = and go to your second workbook and click in the cell you want to compare it with. Go back to original work sheet you should have something resembling the code below but with Workbook in place of Worksheet. The IF statement comes in 3 parts. First part are the instructions of what you want to do =IF(Workbook1!A1=Workbook2!A2,where workbook = workbook name and sheet(this its' why it's best to click in the cells you wish to work with as Excel will give you the cell reference automatically). Second part is what will happen if A1=A1. in this instance A1. The third part is what you want it to do if A1 does not = A1 in this case "" meaning print nothing. You can type what you want between the speech marks and it will be displayed. Try it in a practice workbook just between 2 worksheets so you get the general idea. M =IF(Sheet1!A1=Sheet2!A1,A1,"")

Here I've done it for you just replace your values where necessary. =IF(A2=[Book2]Sheet1!$A$1,A2,"No Comparison") M

thank you for your advise M and pardon me for not asking my question properly(fully). when my 1st cell in worksheet A does not equalls to 1st cell in worksheet B. how do i make it to compare with second cell in worksheet B and so on till the last record? pls advise

thx M for your reply and pardon me for not asking my question probably. but what i actually need to do is 1) to compare two columns of data in two different worksheet. 2) if the first record of (lets say) worksheet A is not equall to first record of worksheet B. i need it to compare with the second record of worksheet B and so on until the very last line pls advise.