|
|
Conditional Formatting 4th Condition by
Dax Arroway
Help with conditional formatting please. I'm designing a "tickler" sheet to
get cells to color by comparing itself to the date of another cell. There's
4...
|
|
3 |
116 |
|
|
Conditional Format Tracker by Date by
Dax Arroway
I'm building a tracker to make sure paperwork is done on time.
Headers:
A:Name
B:IDNum
C:Phone
D:StartDate
E:Plan
F:Paperwork
G:30DAuth
H:90DAuth
|
|
0 |
101 |
|
|
|
|
1 |
104 |
|
|
|
|
2 |
114 |
|
|
Room Occupied Checker Formula Help by
Dax Arroway
I have a worksheet with Headers: A:Name, B:StartDate, C:Room#, and D:EndDate.
I'm looking for a formula that will check the availability of a room based
on...
|
|
5 |
90 |
|
|
|
November 17th, 2009 06:51 PM
by Pete_UK
|
3 |
101 |
|
|
CF to Row after CF is applied to Column by
Dax Arroway
Can someone please help me? I've read through the postings and the help
files but still can't seem to figure out how to do this. I've applied
conditional...
|
|
2 |
115 |
|
|
CF for Row when CF is applied to Column by
Dax Arroway
I've read through the postings but can't find an answer to my issue. Seems
simple enough but I can't figure it out. I have a spreadsheet which I've
applied...
|
|
2 |
133 |
|
|
CF Row after CF applied to Column by
Dax Arroway
I've been reading the posts but still don't get it. I have data down columns
A:O for 2000+ rows. In Column J, I selected the entire column and applied CF...
|
|
4 |
125 |
|
|
Help w/simple Date Formula please by
Dax Arroway
I've got two columns (D, E) headed DOB and Age. Basically what I'm looking
for is a forumula which looks at D, puts the amount of years in E as...
|
|
6 |
145 |
|
|
Charting % of Instances by
Dax Arroway
I need a chart that shows a number of times that someone's been through our
system.
I have a list of names in column B. Some are there once, some are...
|
|
3 |
66 |
|
|
Day Counting - OPEN & CLOSED by
Dax Arroway
I have three columns:
A=Start Date
B=End Date
C=Days
I'd like to count days if there is or is not an end date. So if the start
date was two weeks ago but...
|
|
9 |
255 |
|
|
Current Patient Count by
Dax Arroway
Oh Excel Gurus, please hear my plea!
I've got sheet1 named Patients with
A = Name
B = StartDate
C = EndDate
I'm looking for a formula that I can enter on...
|
November 19th, 2008 12:23 PM
by vezerid
|
4 |
66 |
|
|
Count Names NOT #N/A by
Dax Arroway
I have a list of names (column A) which ends in a bunch of #N/As (because
they include formulas that are... well... N/A) and I'd like to count the
names, not...
|
November 18th, 2008 11:07 PM
by T. Valko
|
2 |
62 |
|
|
Pull Data from one sheet to another by
Dax Arroway
This should be a pretty easy formula but I can't figure it out. Will someone
please help?
In SQL I'd say GET SS# from Sheet1 where NAME EQ Sheet2!A1.
In...
|
November 20th, 2008 02:44 AM
by T. Valko
|
1 |
63 |
|
|
CountIf Not Multiple by
Dax Arroway
I'm trying to count a column that doesn't match a few selections. For
example, I want to count all cells in column A which doesn't contain blue,
green, or...
|
|
6 |
58 |
|
|
NUB Formula Question by
Dax Arroway
How do you got part of the formula to stay and the other part of the formula
to change when using the drag down handle?
For example:
I have
A1=data ...
|
|
1 |
63 |
|
|
SUMIF NOT #VALUE Question by
Dax Arroway
I'm trying to SUM a range Q3:Q33, but this range has values in it that get
calculated from other places that will be calculated through time. In the
last...
|
|
3 |
61 |
|
|
Excel is totaling wrong by
Daxy
I am having a problem with the sum on only one cell of my spreadsheet. I
have currency in cells G2 to G7, (ex: $64,000.00) I have a percentage in
cells H2...
|
|
1 |
131 |
|
|
|
|
2 |
147 |