|
|
|
|
6 |
70 |
|
|
if statement when cell is blank by
davisk
If G3 is a date and F3 is equal to
IF(G3TODAY()-2,"OPEN",IF(G3TODAY()-3,"PAST DUE"))
How do I return "n/a" to F3 if G3 is left blank?
|
August 10th, 2008 12:03 AM
by davisk
|
6 |
112 |
|
|
Question 1 of ??? by
Connie Martin
I am going to have a few of these type of questions, I think, unless I can
plough through this myself. The first formula needs to built like this:
In C10...
|
|
3 |
100 |
|
|
If & Count Statement by
Chris
I cannot seem to find an answer, so I am posting he
A B C D E F G H
1 1 5 3 4 2
2 1 ...
|
|
8 |
114 |
|
|
circular reference by
circular reference
I am trying to make the following functionality:
Two cells:
1. cell A1 which in it I will write a price without VAT.
2. cell A2 which in it I will write a...
|
|
2 |
142 |
|
|
simple grouping question by
Cindy B
Hi-
I think this must be doable, but can not quite "get it". I want to group a
sheet by the first column - and be able to expand it to see the detail when...
|
August 9th, 2008 10:04 PM
by Ragdyer
|
5 |
93 |
|
|
|
August 9th, 2008 09:53 PM
by shan820
|
4 |
88 |
|
|
tab key in Excel jumps cursor cells by
TennisFan63
Running Windows XP SP2 and Office 2003, Tab key in Excel has started to jump
multiple cells to right whenever I use it to navigate (instead of to the...
|
|
4 |
86 |
|
|
three conditional foramats by
Miree
I am trying to create a sheet with no code so it is easily maintained. I need
to put in some conditinal formatting but can't get my conditions to work...
|
|
1 |
74 |
|
|
Sumproduct with cells 0 by
fr8dog
I'm having issues counting cells with a value of 0. The cells that I'm
counting are being filled by another function, but will always be a number.
When...
|
|
3 |
79 |
|
|
|
|
1 |
90 |
|
|
I need spreadsheet formula help PLEASE!!! by
brebrian
Hello,
I am trying to create an Excel 2003 spreadsheet that will calculate
compensatory time. The colums that I have are Earned time (column E) Used
time...
|
|
2 |
91 |
|
|
|
August 9th, 2008 06:00 PM
by meag
|
0 |
111 |
|
|
Record dates based on criteria by
HappyDaddy
How do I record the date when a specific cell reaches a specific value?
ie:
Cell "A1" increases in value based on user input. Starts at zero on day one
and...
|
|
7 |
119 |
|
|
Challenge with target output by
New Ton[_2_]
Hello everyone.
When added, this code inputs changed values in a range ("g5:g29") to
specified ("g31") cell:
Private Sub Worksheet_Change(ByVal Target As...
( 1 2)
|
|
10 |
112 |
|
|
|
|
1 |
85 |
|
|
|
August 9th, 2008 11:44 AM
by Mike H
|
2 |
81 |
|
|
Extract file name by
Steven
What function would extact the name: 84DTCC 2008_05
out of this.
G:\CorporateAcct\SMR\Special\Support\84DTCC 2008_05.pdf
Note that the directory and...
|
|
8 |
85 |
|
|
Pls help with Excel Function by
TotallyConfused
I have a list of thousands of records. I need to identify duplicates. There
can be more than one duplicate. I am using this function...
|
|
1 |
72 |
|
|
Fill Mon-Wed-Fri dates? by
LynneCreek
I'm a college instructor and would REALLY like to find a way to automatically
fill the dates for MWF classes or for T-Th classes. So far all I can get
excel...
|
|
6 |
79 |