|
|
Need help with formula by
Donna
Hello all.
How do you write a formula for cell K1 to read “PEDS” if the age in cell C1
is from 1 – 18?
I don’t want PEDS to appear in K1 if C1...
|
|
2 |
145 |
|
|
|
|
1 |
210 |
|
|
delete numbers in each cell in same column by
Anna Huber
Is there an easy way to just delete the first two numbers in each cell all
the way down the column? i.e. 123456789 to 3456789? Would I have to create
a...
|
June 11th, 2009 10:33 PM
by RagDyer
|
7 |
144 |
|
|
Pivot across several tabs by
Tami
can you pivot across several tabs?
i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on
tab2....and my buyers are very good at pivots...
|
June 11th, 2009 10:03 PM
by Tami
|
2 |
166 |
|
|
Combo box selection will not calculate by
Perrysbox2
I am using 3 combo boxes to select the year, month and day for a scheduling
worksheet. Each combo box is linked to a cell which is 'named' accordingly.
When...
|
|
1 |
144 |
|
|
What Formula to use? by
Paul Chung
Hello everyone, I'm trying to figure out how to have excell show me a number
based on the value of another cell. Here is the cell info:
1 1.0 0.999...
|
|
6 |
142 |
|
|
|
|
3 |
120 |
|
|
|
|
5 |
192 |
|
|
Importing by
newbo
My posi installation used dBase 5 (only dBase 5) standard drivers.
But the dbf files appear to be part of an export process? (I would
guess--only a few hours...
|
June 11th, 2009 08:41 PM
by newbo
|
0 |
108 |
|
|
|
|
1 |
167 |
|
|
Formula for rating results by
Nadine
Look for a help creating a formula, if it possible, to find out the overall
rating results
example - first row going across lists all the options provided -...
|
June 11th, 2009 07:27 PM
by Nadine
|
4 |
123 |
|
|
standings by
Kashyap
Jean 06:52
Jackson 05:12
UmaU 00:00
Peter 05:36
Joseph 02:48
in the above table how to find out the standings of each? that...
|
|
3 |
120 |
|
|
Using the "Count" function with filters? by
Irv
I need to find a formula that counts the number of cells in a column that has
data (text, &/or number), but the kicker is I need that number to change when
I...
( 1 2)
|
June 11th, 2009 06:55 PM
by icsonu
|
13 |
211 |
|
|
Conditional Formatting Based on Due Dates by
Morgimo
I want a stop light color to change from green, yellow, or red based on a
specific number of days prior to the due date. For example:
If A1 is the stoplight...
|
June 11th, 2009 06:15 PM
by Morgimo
|
3 |
127 |
|
|
Summing data based on certain cells by
MurrayBarn
I have a spreadsheet that has data for each month. At the bottom of each
month is a summary of the data in four categories. What I need to do is for
the data...
|
June 11th, 2009 05:46 PM
by RagDyeR
|
4 |
114 |
|
|
Updating & Archiving Records by
sandy
Hi,
I am using Excel 2007.
I have a large spreadsheet and new data is added periodically.
I have several columns of data associated with a description &...
|
June 11th, 2009 05:43 PM
by sandy
|
4 |
189 |
|
|
IF with #N/A by
Rahim
I want to tell excel that IF A2 has "#N/A", AVERAGE (A1,A3), A2
but it don't work, any help is highly appreciated, thanks
|
|
3 |
145 |
|
|
SUMPRODUCT by
PAL
I am using the formula below and it seems to work fine.
As an array:
=SUMPRODUCT(--('Enroll I'!$O$2:$O$2741="Regular"),--('Enroll...
|
June 11th, 2009 05:20 PM
by PAL
|
4 |
121 |
|
|
|
June 11th, 2009 05:09 PM
by Luke M
|
5 |
152 |
|
|
Conditional formatting from Dates by
DavidM
Today's date will be manually entered in to a header cell.
The worksheet contains the dates that customers last purchased from me.
How can I change the colour...
|
|
3 |
136 |