I am looking to have Excel recognize that a date is between a certain
period and put a month label in the next cell.  Basically, it would
see in A1 that the date is between January 1 and January 31 and would
put the label "January" in B1.  Is there any way to do this so that it

I am responsible for Paper products bought, I need to set up a spreadsheet
for purchases on a quartley basis to track spending per department (3).
Is there a template out there in webland that I can use instead of setting
up my own? Being I have no idea how to? I have never used ...

I am trying to enter a formula into a range of cells and in the
formula the row range also has to change.  My error seems to be with
"range1" and it is not returning a cell but says "range1".  Any
ideas???

I've been using SUM-IF array formulas since Excel 4. But recently, I've
tried to use SUMPRODUCT instead.
That is...
{=SUM(IF((Name="Smith")*(State="Utah"),Amount,0))}

Trying to load ComboBox from Dynamic Array
Code: Declaration: Option Base 1, Public MyArray()
          Procedure: N = 1
                             ReDim MyArray(N)

I need a solution to the following problem. I have two columns of values. I
need to find the subtraction of the sum of two column. I can do it maually
by entering the range. What i need is solution that will scan each scan
untill the cell is empty, sum the cells of two column and ...

We have this spreadsheet which resides on a network share (M drive),
within this spreadsheet there are numerous rows of data, each one
refers to the M drive, via a hyper-link this then opens another
spreadsheet on the M drive within a seperate folder. The problem I

I have a problem with a date format, and I have no clue how to
convert
it into dd/mm/yyyy
It now says for example  04/16/2013 however the Cell Format says

I have created a worksheet and only the user input cells are unlocked.
Is there a quick way to see which cells are locked and unlocked, this
for me to see which I have missed, if any.
Many thanks

i have these set of values in a column, how do i apply the same formula to
all of the values in the column? sorry please help.

Excel adds double quotes when an entry contains special characters
when saving as CSV or tab delimited, microsoft publishes a macro to
fix this, but I am having trouble with it, any other solutions?
Support.microsoft.com/kb/104997

I have some groups and I want each group to have different color(not
necessarily distinct).
thanks.

I have created a list of names in a procedure storing to a Dynamic
Array, but do not know how to enter then into a ComboBox List.  I
declared the array as Public and String.  Need help
Thanks,

When create a new file in excel with multiple columns and save as CSV,
when I re-open everything moves to the A column.  How do I prevent
this?

I have a ranged defined in a spreadsheet that consists of a bunch of
values.  Some of the cells in the range may be empty.
I also have 4 hidden lookup tables at the bottom of my spreadsheet.
Using these 4 lookup tables, I know how to use the vector form of the