|
|
Conditional Format based on date by
Ron A.[_2_]
I need to have cell A3 to be filled with red and show "within 90 days" based
on the current system date being equal to or less than a date entered in cell...
|
|
2 |
60 |
|
|
Calculation using IF by
Bill R
I want to use the IF function to perform a simple calculation. In cell C4 I
would enter one of three place names. In cell F4 I'd like the formula to use
a...
|
|
6 |
61 |
|
|
|
|
1 |
46 |
|
|
Same formula on multiple sheets by
onebodaciousbabe03
How can I get the total of a specific formula on worksheet 1 to be on
worksheet 2 as well? I hope the question makes sense. Thank you in advance
for the...
|
|
1 |
57 |
|
|
|
March 23rd, 2009 05:47 PM
by Lynn
|
7 |
110 |
|
|
|
|
3 |
42 |
|
|
|
|
9 |
58 |
|
|
Calculation using IF by
Rankine93
I want to use the IF function to perform a simple calculation. In cell C4 I
would enter one of three place names. In cell F4 I'd like the formula to use
a...
|
|
1 |
48 |
|
|
HOW TO HIDE ALL EXTRA ROW AND COLUMNS by
dvalderrama
i want to hise the rest of the worksheet for example i have a gride that is
like 20 cells by 20 cell, how can i just have that one boxe showing instead
of...
|
|
3 |
50 |
|
|
Sum If function by
Ranjith Kurian
I have two sheets, sheet1 and sheet2, Sheet1 contain all data and it has
three columns Name1, Name2 and Amount.
Sheet2 have two columns Name and Amount, so i...
|
|
3 |
90 |
|
|
LOOKUP Question by
Tam
I have a table with several columns,one of which is a column of numbers from
(1-15) that reference a certain item. There are several instances of the
same...
|
March 23rd, 2009 04:53 PM
by Bernd P
|
3 |
95 |
|
|
realtime list sorting/data exraction by
Richard Edwards[_3_]
Afternoon all,
I have a list of order id's in column A (that are updated in realtime) and a
list of their instructions (if any) in column B.
One user deals...
|
|
4 |
59 |
|
|
Need help with Line Chart... by
Fergal[_2_]
Could somebody please tell me if it is possible, using Excel (Office 2007)
to make a very basic Line Chart, for example:
I have two columns, column one "DATE"...
|
|
5 |
51 |
|
|
Averaging scores by
birdieman
I am trying to select the 10 lowest scores from the last 20(changes weekly)
and average them. What is the easiest way to perform this function.
|
|
3 |
55 |
|
|
Date compared to today by
BethD
I have a worksheet with two columns (Appraisal Status and Appraisal Due Date.
Both columns are filled with data from a separate worksheet using the
VLOOKUP...
|
March 23rd, 2009 04:23 PM
by Pete_UK
|
4 |
74 |
|
|
Moving object by
MAX
Can one make a moving object in excel for example a ball rolling or bouncing?
|
March 23rd, 2009 03:34 PM
by MAX
|
2 |
52 |
|
|
Calculating Elapsed Time by
Rosemary
Hi,
We have MS Office 2003, Windows XP, in a network environment.
I have a worksheet that calculates time elapsed. Currently, the result is
displayed as...
|
|
2 |
106 |
|
|
INDIRECT function returning REF# by
Don Kline
I'm trying to find the start of a column on a worksheet. The column start is
based on two variables - row number and column number.
The value of RC2 =...
|
|
2 |
61 |
|
|
protect sheet but column width changes by
Gene
after protecting the worksheet (tools protection protect sheet) I email
the document and when opened the column widths and heights are slightly...
|
|
1 |
53 |
|
|
Don't know if its possible in Excel by
cdwheel
Hello, I've been trying to work a formula, but I'm not even sure if
Lookup is the right one for this. Let's say I work in a pet shop and
I'd like to register...
|
|
4 |
69 |