I have a list of names that shows first and last names in one column (entry
="John Doe") I want to separate these into two columns so that I have one
column with entry="John" and next column has entry="Doe". I can do this the
loooong way bt copying the first column over twice, ...

I have a spreadsheet that is 8 columns by 1000 rows. each cell contains a
number from 1 to 100. I need to find out which numbers in each column repeat
the most often, then the next most frequent.
I thought that the frequency command would do it but I can't make it work on

i have a workbook with 2 worksheets in it. My data is all on the second
sheet. Many of the cells have comments in them. I want to link the data on
the 2nd sheet to the first sheet with the comment included. Does anyone know
how to do this or if this  is even possible?

I have a column where I'm using IF statements to return a value from another
column if certain conditions are meet and "" otherwise.  Previously I had
manually enter that information and then did a count of any cell in that
column, using COUNTA, that contain a value.  But, since ...

I need to copy cell from a list, which has been sorted, to another worksheet.
The problem I run into is that the sorted cells are not contiguous and the
source cells fall out of the target range.
Example; the cells in the following two columns need to be copied only if

I have 5 times fields the start times are in columns A & B and the end times
are in Columns C, D & E. They are not in order, but cols A or B are always <
C, D or E.  How can I get the #of minutes between the earliest start time and
latest of the end times.  

I have 2 worksheets that are setup as follows:
wksht1:
column a = customer number
column b = customer name

I am trying to merge two cells together from a different worksheet with the
values separated by the plus/minus symbol into one cell.  I would also like
to retain the auto-update portion of if those values change in that sheet
they will in this new worksheet as well...

Would like to allow user to be able pick amongst Multiple worksheets via
in-cell dropdown and formulas to change.
IE - what do I have to do to make
=SHEET1!D5

Here's what I'd like to achieve:
It's for budget planning.
In b3, if b1>=b2, then display value of (b1-b2); if b1<b2 then hide value or
display nothing.

Please help me.
I try to run a SUMIF worksheet function from my VBA code.
Basically this is the troublesome line.
MsgBox Application.WorksheetFunction.SumIf("$E$1:$E$226", ">0", "$N$1:$N$224")

I'm creating a spreadsheet that different users will use on a network of
computers, with there own "sign ons" as such (its at my place of work).
Different users will be adding dates for when items have been received. for
example cell a1 would be the date they have entered, and ...

I am expecting the answer as 2007 from the function of =YEAR(3/7/2007)

On a previous pc where  Excel 97 was upgraded to 2003 I was able to copy  
numbers with a negative behind it eg 1564- from a mainframe application and
paste it into Excel and it would automatically format it as a negative eg red
(1564.00).

I have a spreadsheet that has manual calculation turned on. My problem is
that after turning automatic calculation on then saving and exiting the
spreadsheet this change will not be saved. The next time I open the file
manual calculation is on again. I only have this problem on ...