I have a spread sheet that has the following info:
Column A = Date, Columns B:D = times associated with shifts, i.e. B4
11 p.m. - 7 a.m.; C4 = 7 a.m. - 3 p.m.; D4 = 3 p.m. - 11 a.m. S
A5:A237 is a date, B5:D237 is a number based on the amount of wate

We are working on our catalog price sheet.  We have figures as follows:
$152.50                  $161.75                   $158.00              
$157.00
I want the numbers to round up or down to the closest $5.00.

I'm using excel 2003... I have a column (C7)with 16752 rows of #s 0 thru
24... I need to separate this column into ranges... i.e. <3; >=3<5; >=5<8,
etc... can i use an =if function to do this? I have tried
=if(C7>=3<5,C7,"")... just returns a blank???

Hello.  I am trying to copy a worksheet that was linked to another file which
is on a server with limited access.  I need to copy this single worksheet,
not entire workbook, to another users computer who doesn't have access to the
source files.  When I open the document I get a ...

I have a range of numbers, A10:L10, which represents headcounts during
the month.  These numbers are a formula, not a manual input.  If the
month has not occurred yet, the number equals 0.  I want to add a
formula telling me my average headcount per month.  However, because

I am trying to return an array of dates and prices from a worksheet function
and display them starting at the selected item.
This is the function I am using to test.  I've seen this done by people such
as Bloomberg but cannot work how to do it at all.  Any help would be much

Hi~
I am trying to insert a listbox by the way of validation and would like
to only have unique data displayed in it.  I have seen some people
finding unique records but I don't know how they would display them.  I

I am trying to enter a formula to calculate an entire row.  
example: i want to take the total in each cell and multiple it by a new price.

I have 1 workbook with 2 worksheets.
Worksheet 1 has:
Column a
nm123

I'm trying to concatenate address components (Address Line 1, Address Line 2,
City, State, and Zip Code) from their individual cells into a single cell
that is formatted correctly in 2 or 3 lines of text.  In my formula, I'm
trying to find a way to output Address Line 1, start a ...

I am try to create an if statement with 3 arrays, I created 2 arrays
and I am having trouble creating the third array.  What I am try to do
is to have the sum of the cells in the row equal 6100.80.  I need a
statement to calculate the difference in the cell that will take me to

I have mutiple sheets of information for which i want to sum values in column
p if columns c & d meet specified criteria.
The formula i have at present is
=(SUMPRODUCT(SUMIF(INDIRECT("'"&$AE$11:$AE$26&"'!$d$9:$d$65536"),$A11,INDIRECT("'"&$AE$11:$AE$26&"'!p$9:p$65536"))))

Quick question. I have this array formula:
{=SUM(IF(Sheet1!A1:A6="Jim",IF(Sheet1!B1:B6="Phone",1,0),0))}
And I'll quickly show you what the chart looks like:
A                         B

I cannot seem to get the row height Autofit function to work when typing text
in Excel. When in the cell or cells I want to expand automatically and go to
format >row>auto fit the cell shrinks to one line though I have typed
multiple lines of text. How do I get it to expand to ...

I want to create multiple cells within a cell. Example,
Column 1: Name and Surname ,    Column 2: Personal Details,    Colums 3:
Training Results,      Column 4, Test Results
When I clink on Column 1 and select teh name, I automatically want Column