Copying "Exact" Function

N

Nats_uk

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
 
J

Jacob Skaria

Check out the calculation setting from Tools>Options>Calculation..(Should be
Automatic..)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error in Copying "Exact" Function 1
Change a great number of words in word files, with a macro as short as possible. 5
Word macro that can call cells out of Excel for a find and replace 0
Select Text to End of Footnote 9
EXACT function vs. equals operator 11
Macro to Select text from a point given to a specific word 2
VBA word change keys 0
Loop through pages and insert header image 0

Top