Cell Funtion related to Adjacent cells

[anjanesh]

Hi

My E2 cell has *=IF(C2=D2,"Same","Different")*
Now I want E3 cell to have *=IF(C3=D3,"Same","Different")* right dow
to E1000 having *=IF(C1000=D1000,"Same","Different")*

What kind of copy-paste do I need to do here ?

Thank

 

[Ragdyer]

Just click in E2, and hover the cursor over the lower right corner of the
cell until the cursor changes from a fat, white cross to a skinny, black
cross.
Then, click and drag down to perform a simple "Copy".

Your formula is constructed with 'relative' cell references, so that the
references will *automatically* increment as the formula is copied down.

 

[Bearacade]

do a drag and filll; mouse over the lower right hand corner of your E
cell, until it turns to a black skinny cross, left click and hold an
drag all the way down to E100

 

[anjanesh]

Cool ! Thanks.
Now that I got the same and different ones, I want to get rid of th
function call in each cell and have it replaced by the ouput tex
(*same* or *different*) so that its searchable - because when
highlighted the column and gave a search for different, it showed al
1000 ! Its clearly searching within the tex
*=IF(C-n-=D-n-,"Same","Different")

 

[Bearacade]

You can copy the range, paste special, value only

 

[Gord Dibben]

Select column E and Edit>Copy.

With column E still selected.....Edit>Paste Special>Values>OK>Esc.


Gord Dibben MS Excel MVP

 

[Ragdyer]

There should be *no reason* to have to change the formulas to their values!

When you go to,
<Edit> <Find>
At the bottom of the 'Find' window, you have a choice as to *where* you wish
to search.
Change the "Look In" box, from 'Formulas' to 'Values'.