Prev: Which function will shorten IF-THEN-ELSE ?
Next: same problem here
From: Nats_uk on 18 May 2010 07:21
I have an excel spreadsheet with two columns, legal forename and preferred
forename. I ran a "exact" function so it would appear true if the two
surnames were the same or false if not.
There are 180 odd rows so I wanted to just copy and paste or drag the
"exact" formula instead of having to manually entering it for each row.
However whatever method I try the cells all display TRUE, if I then click
into one which I know should be false and click enter then it changes the
result to FALSE.
I don't want to have to do this for every row

From: Jacob Skaria on 18 May 2010 07:28
Check out the calculation setting from Tools>Options>Calculation..(Should be
Automatic..)

--
Jacob (MVP - Excel)


"Nats_uk" wrote:

> I have an excel spreadsheet with two columns, legal forename and preferred
> forename. I ran a "exact" function so it would appear true if the two
> surnames were the same or false if not.
> There are 180 odd rows so I wanted to just copy and paste or drag the
> "exact" formula instead of having to manually entering it for each row.
> However whatever method I try the cells all display TRUE, if I then click
> into one which I know should be false and click enter then it changes the
> result to FALSE.
> I don't want to have to do this for every row
>
From: Dave Peterson on 18 May 2010 08:04
Check your other post.

On 05/18/2010 06:21, Nats_uk wrote:
> I have an excel spreadsheet with two columns, legal forename and preferred
> forename. I ran a "exact" function so it would appear true if the two
> surnames were the same or false if not.
> There are 180 odd rows so I wanted to just copy and paste or drag the
> "exact" formula instead of having to manually entering it for each row.
> However whatever method I try the cells all display TRUE, if I then click
> into one which I know should be false and click enter then it changes the
> result to FALSE.
> I don't want to have to do this for every row
>
 | 
Pages: 1
Prev: Which function will shorten IF-THEN-ELSE ?
Next: same problem here