I have names and surnames both in a single cell?
I want to separate them in different cells.

I am having three columns
DATE, DESC, AMOUNT
I want sum the amount based on month of the date-column ( Not sorted).
Thanks & Regards

    Is it possible to calculate the date that has occurs?
If the Format like this:
Sheet 1:
Date

Does anyone know if it is possible to assign a value to a number, say 1, that
when entered into a cell it will automatically change the formula in
corresponding cells.  EG. If 1 = +10days
I enter 1 in b3, then the formual in b5 will change from +20days, to +10days

I have attached below, the sample of the data i am working with. 2 columns, 2
rows. Considering this data to be on the same excel sheet, which formula can
i use to calculate the sum of hours for both weeks, for each employee. Im not
sure which formula to use.

Hi all, I would like to ask if anyone can suggest me a funtion or a formula
in Excel on how to calculate the difference between two dates in the format
of DD/MM/YYYY or similar to this, considering real number of days in a month.
The function DAYS 360 can calculate this, but only ...

I want a Macro to run only if a cell listed in column B says "Red" to create
a seperate spreadsheet.
I currently have 86 line items in this sheet which could potentially go
"Red", so the Macro needs to run each time this happens.

I'm bamboozled!...and would welcome assistance from someone with greater
understanding of nesting functions than I.  I've got the first bit, but can't
work out the next part:
Part A: If the value in cell M24 is found in range A2:a500, and if the item

I have set a sheet background.
Yet when i print the sheet i get NO background
How do i fix this ?
Corey....

I am wondering one groovy function that
1. Selects values according to my criteria, such as more than 0 (zero) AND
less than 5000, and
2. Take standard deviation of the selected values.

Hope there is someone that can help me out.  I have tried everything I have
read on eliminating #N/A to appear.  I've tried the =IF(ISNA(myformula),"",my
formula).  Basically my formula reads like this.  It's looking up Prices and
I'm trying to get a return of "$0.00".

I need to calculate a geometric mean for an array of numbers of which some
are negative.  The geomean function in Excel does not calculate if there are
negative numbers in the array.  I'm not sure what the purprose of the
function is if you can't include negative return numbers, ...

I have multiple worksheets and any time something is entered on one of them I
want it to show up on my totals page.  As an example we have mulitple sheets
with the headings.  They must be all in separate sheets and can not be
combined into one.

Hi there All
Can anyone help me ? I am trying to find a way of...... Example
1,2,3,4,5,6    I want to write a formular that will list in the spreadsheet
the combinations of say 3s. The answer to this would be:

Well, I know that we can use a named range with a offset function in a SERIES
function from a chart. So, the chart will have more interactivity.
I want to know if can I use a function or a named range to interact with a
linked object inserted by Insert -> Object (Option 'Link to ...