Blank Cells
Tue, 14 Oct 2008 13:36:01 -0700
Hi,
I'm struggling still with a problem I have. It seems simple enough but as
I'm fairly new to working with spreadsheets, I can't figure it out.
You know when you complete say, an online order form and if you haven't
completed a field you get asked to fill it in? Well, I have to create
something similar ...
|
Copying printable area
Tue, 14 Oct 2008 13:22:12 -0700
In all previous versions of Office, I could copy the printable area in Excel
(including charts) and paste special as enhanced meta file in Word with no
problems. With Office 2007, the chart area is always in the wrong place (ie
smaller). Is this a Microsoft Excel bug or am I doing something wrong??? ...
|
Enter formula that uses values from other cells
Tue, 14 Oct 2008 12:13:01 -0700
I want to enter a value in one cell that will produce a result based on
values in other cells. For example: Cell B5 has a drop down list where I
select the level of Tobacco use (mild, moderate or heavy). Once I've selected
from the list, I want to return a value in C5 that reflects not only my B5
selection, ...
|
I need a formula to add up the sum of an employee
Tue, 14 Oct 2008 12:03:00 -0700
Hi i have a sheet for employees that capture weekly hrs for workers, after
four weeks i now want to use a function to sum all monies paid to each
individual within the four weeks. but my sumif and sumifs dont seem to be
helping. simply i want to see the total amount for an employee but wont want
to add the u ...
|
Pivot Tables in Office 2007
Tue, 14 Oct 2008 11:32:00 -0700
Did something change in the way pivot tables are constructed in Office 2007,
in addition to the obvious improvement in the onscreen interface? I am
having a devil of a time pulling out calculations which make sense. ...
|
How do I count a red number
Tue, 14 Oct 2008 11:31:03 -0700
How do i count a range of cells that have a red character; like a red 0? ...
|
delete and rename tab options are grayed out
Tue, 14 Oct 2008 10:10:00 -0700
The delete and change name options on all of my excel worksheets are grayed
out, I can't delete unused tabs or change the names of exsisting tabs. ...
|
|
|
Followinf Friday of a certain day
Tue, 14 Oct 2008 09:56:13 -0700
I have in cell "A5" one day of the month
I need a formula in "A6" that gives me the following
friday of that specific day based on the input on "A5"
Any ideas??
Thanks ...
|
Wierd Data sorting
Tue, 14 Oct 2008 09:43:00 -0700
I have a spreadsheet with 12 columns. I'd like to sort on any one of those
columns at one time or another. However, when I "Sort Data" on a column (it
doesn't matter which column) All of the columns are resized to about 2 words
across. Since I have word wrap on and one of my columns contains a 50 - 75
wo ...
|
Look up
Tue, 14 Oct 2008 09:37:00 -0700
I am doing a Lookup array. I am getting everything except one item
=LOOKUP(L17,L565:M569)
My array:
Dry/Dry 1
Dry 2
Dry/Wet 3
Wet 4
Wet/Wet 5
I am getting the correct information for all of my catagories except Dry. It
will show a N/A. I am not sure why this is hap ...
|
