|
|
|
June 24th, 2009 08:32 PM
by Luke M
|
3 |
153 |
|
|
How to update a cell after a calculation? by
Tony
I am creating a spreadsheet that keeps track of my inventories. I want to
set it up to do a calculation using a cell, and then update that cell with
the new...
|
June 24th, 2009 08:30 PM
by Mike H
|
1 |
159 |
|
|
Comparing two colunms by
Red Deer Tech
I have a user that is trying to do the following:
In column A is a set of numbers (for this example we will say 40 rows)
In column B is a set of numbers (for...
|
|
1 |
254 |
|
|
|
|
1 |
204 |
|
|
if statment by
Stuntz Waldorf
I have a cell (b1) formatted as ddd, d-mmm-yy and I need cell (a1) to show
"weekend" if the cell (b1) is a "Sat" or "Sun". What is the proper syntax for
this...
|
|
4 |
234 |
|
|
|
|
4 |
215 |
|
|
@IF Formula by
Ann 'Formula challenged'
Hello, I struggle incorporating @IF formulas.
I have three date columns. I need to find the work days between any two
dates.
My challenge is when I use...
|
|
3 |
258 |
|
|
Range - using in code by
Stephanie
Hi, All! Excel coding is a whole new ball game!
I set ranges (A5:F11) as "PeopleDrivers" and range (A13:F26) as
"ProcessDrivers".
Column F is a "Click here"...
|
|
5 |
139 |
|
|
Modification Time Update by
Kanmi
Please i want to modify this formula to change when column content below it
change. "=TODAY()" or if other way to do it.
A ...
|
|
3 |
333 |
|
|
AUTOMATIC COLUMN TRACKING by
Kanmi
I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW
WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS"
AFTER...
|
June 24th, 2009 06:41 PM
by Kanmi
|
0 |
164 |
|
|
|
June 24th, 2009 06:30 PM
by Picman
|
4 |
122 |
|
|
Name by
Talladega
Hi,
I have two colums, check number and number of months. I want to create a
formula showing if it is more than 36 months then it shows "Check No. 457" if...
|
|
2 |
179 |
|
|
Counting with multiple matching criteria by
Gary''s Student
A colleague came to me yesterday and complained about the length of formulas.
She needs to count occurrences of values in a table that meet any of several...
( 1 2)
|
|
12 |
305 |
|
|
|
|
1 |
173 |
|
|
|
|
1 |
143 |
|
|
sum function by
dannyboy8
I have a row of numbers, both positive and negative and am looking to sum up
these rows, but omit all the negative #s in the sum, how would I write a
formula...
|
|
1 |
149 |
|
|
|
|
3 |
154 |
|
|
COLOUR MANAGEMENT by
Kanmi
I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW
WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS" AFTER...
|
June 24th, 2009 04:16 PM
by Kanmi
|
2 |
134 |
|
|
Column sum will not add by
babzybaby
Ok here is my problem. I am working with a large spead sheet. I have six
columns that are adding up to the correct sum and two that are not
identifying any...
|
|
1 |
143 |
|
|
Chart on Excel 2007 by
milu
How do I change the data on the Y axis set automatically by the program?
I already tried with the 'Select Data' option but it only allows you to
change the...
|
June 24th, 2009 04:09 PM
by milu
|
0 |
124 |