Recently have come to the following task:
There is a table of data like this:
Piter  10 20 30
Ann   15 23 45 54 56

In A1 I have 21-dec-05
I need to get the month into E1 as dec
Any ideas?

If I have the following data in columns A to D:
A       B       C        D
G       2        H       5
2       3        H        8

is there a way to have a header/footer reference values that are on a sheet?  
I have some novice users, for who I'd like to make a very easy to fill in
area of information, and then have the headers and footer of sheets appear
nicely formatted with their information in there.

Hello. How can I get in a worksheet all the values of let's say cell A
or column B from several different worksheets
--
Erwin

Hey guys I'm having a bit of trouble with a formula for barcodes.
I'm trying to get a sequence eg.
eg I will scan this barcode:    HD65B1164281P
and it will go up like this        HD65B1164282P

I'm doing a spreadsheet  and would like some help. I want the foumula to
comapre one cell and if it has the gift in it and the next cell over is below
40 then the value of the cell if over 40 then 40. Easy enough? no, I also
want if the first cell has the word  membership in it ...

Hello, would be grateful if someone could help me here. I have 2 lists of
names in 2 different columns. one column has the names first and then last,
the other has the names last and then first. Ive used a foruma provided by
someone else on this site to reverse the order which ...

Hi! I have hidden som rows and columns in some of the worksheets in an excel
file I have made. I need to do this in order to shield my basic data from
some of the users. WHen I did this all pictures disappeared from all of the
worksheets (e.g. logos on the first sheet) - even ...

I would like to write an if function to accomplish the following:
=IF(A<16000,0, next part ?
I want to continue to state if A1>16000 then *the difference by10%
                         Thanks for any help

I want to hide a few columns in a price list and password protect them.  I
also want to password protect a group of non-hidden columns.  I do not want
to password protect the entire sheet.  Is this possible?  Thanks.

I am looking to produce a formula that shows if a number is "found" or "not
found".
I have list of over 1000 numbers in one column (1 number per row) . I am
trying to identify if those values are present in a range of numbers from

I have in column AU cell 39 to cell 500 random sequences of 1-10 rows ,
with numbers in them, (as an result of formulas)
I need to count the number of rows in each sequence that have numbers
of  35  or less , but only up to the first number of  35 or higher.  eg:-

I would loke to export a report from quickbooks to excel. Can someone walk me
through

I have a spread sheet that I keep the employees schedule in. What I'm trying
to do is let excel keep a tally of total hours for me.
A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day.
then C13, D13, E13, F13 etc etc has her schedule input the same way. (24