|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 18th, 2010, 12:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying "Exact" Function
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 
|
|
#2
May 18th, 2010, 12:28 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying "Exact" Function
Check out the calculation setting from ToolsOptionsCalculation..(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
|
|
#3
May 18th, 2010, 01:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying "Exact" Function
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
