Comparing Two Cells

chku55 · Apr 19th, 2002, 08:24 PM

I've one workbook with 3 different name of worksheet. My question is, I would like to compare the cell at sheet 1 and cell at sheet 2. If the cell in sheet 1(A1=Unique_Identifier) not equal to cell in sheet 2 (A1=Unique_Identifier) then the sheet 3 (A1=Result) will display the value of cell of sheet1.

KnAsTa · Apr 19th, 2002, 08:31 PM

Ok, first of all you need to write the formula into a cell in sheet 3. From this cell type = and click on sheet1. click on the area or cell you want to reference and it should automatically be added to your formula. You then write your compare statement, and then reference sheet2 just like you did sheet1.

I hope this made some sense to you, i just woke up........so could be a little hazy

Yogi Anand · Apr 19th, 2002, 08:42 PM

Quote:

On 2002-04-19 19:24, chku55 wrote:
I've one workbook with 3 different name of worksheet. My question is, I would like to compare the cell at sheet 1 and cell at sheet 2. If the cell in sheet 1(A1=Unique_Identifier) not equal to cell in sheet 2 (A1=Unique_Identifier) then the sheet 3 (A1=Result) will display the value of cell of sheet1.

Hi chku55:
Furthe to what KnAsTa said, you can go directly to cell A1 in sheet3 and type the following formula

=IF(SHEET1!A1=SHEET2!A1,"",SHEET1!A1)

HTH

nisht · Apr 19th, 2002, 11:29 PM

use my file nos 12 'compare range'

http://www.pexcel.com/download.htm

it will give you the solution.

nishith desai
http://www.pexcel.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 08:24 PM	#1
chku55 New Member Join Date: Apr 2002 Posts: 4	I've one workbook with 3 different name of worksheet. My question is, I would like to compare the cell at sheet 1 and cell at sheet 2. If the cell in sheet 1(A1=Unique_Identifier) not equal to cell in sheet 2 (A1=Unique_Identifier) then the sheet 3 (A1=Result) will display the value of cell of sheet1.

Apr 19th, 2002, 08:31 PM	#2
KnAsTa Board Regular Join Date: Apr 2002 Location: Australia Posts: 52	Ok, first of all you need to write the formula into a cell in sheet 3. From this cell type = and click on sheet1. click on the area or cell you want to reference and it should automatically be added to your formula. You then write your compare statement, and then reference sheet2 just like you did sheet1. I hope this made some sense to you, i just woke up........so could be a little hazy

Apr 19th, 2002, 11:29 PM	#4
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	use my file nos 12 'compare range' http://www.pexcel.com/download.htm it will give you the solution. nishith desai http://www.pexcel.com