|
|
percentage formula by
Tracy
I need help with a formula for percentage of the time kids are in class....
AG37 is Absent
AH37 is present
AI37 is the percentage of time they are...
|
|
1 |
89 |
|
|
|
April 5th, 2005 01:22 AM
by CLR
|
8 |
158 |
|
|
how do i turn off formulas in excel by
vachss
I'm entering a 13 digit number into a cell and instead of displaying the
number typed excel converts the number into a formula. Is there a way of
turning this...
|
|
4 |
148 |
|
|
Finding Dates in a date range by
Marcus
I have a column in a spreadsheet that consists of dates in dd/mm/yyyy format.
I'm trying to write a formula that looks at the dates by row in the colum
and if...
|
|
1 |
232 |
|
|
|
|
1 |
471 |
|
|
|
|
1 |
212 |
|
|
Count numbers formed from another formula by
Stephen
Hi. I'm trying to count a set of #s that is formed by another formula. For
example, I have a list of numbers from c1-c6 which all have formulas in the
cell...
|
April 5th, 2005 02:30 AM
by CLR
|
4 |
210 |
|
|
|
|
0 |
189 |
|
|
|
April 5th, 2005 06:02 AM
by Biff
|
1 |
73 |
|
|
|
April 5th, 2005 07:15 AM
by Kassie
|
4 |
114 |
|
|
|
|
3 |
128 |
|
|
Storing macros, userforms by
Jennifer
Well, I just created my very first userform.
Wow, how cool is that.
Anyways, I was wondering if anyone has a suggestion for storing userforms
and macros in a...
|
|
0 |
117 |
|
|
|
|
4 |
186 |
|
|
Edit Links in excel....Urgnet.. by
vishu
Hi,
I have data in Excel file and I have linked to data in some other Excel File.
Whenever I opened file I will not get automatically updated the links,...
|
April 5th, 2005 09:05 AM
by vishu
|
0 |
98 |
|
|
|
April 5th, 2005 09:44 AM
by Andre
|
0 |
159 |
|
|
conditional formatting formula by
Jack Sons
Hi all,
In row 2 I have dates, E2 contains April 4 2005, F2 April 5 2005, G2 April 6
2005 etc.
In A4 to A40 I have names and in E4 to CR40 I have an entry...
|
|
6 |
250 |
|
|
Alpha & Numeric Counts in Excel by
Programmer wanna be
I am trying to add alpha and numerical together. Basically if there
are any alpha characters in a column then deduct them from the total
number of all the...
|
April 5th, 2005 11:12 AM
by CLR
|
3 |
303 |
|
|
extending selection by
Flip
Hi NG,
Here is a small example of a problem I cannot solve:
3 columns
a b c
x 2
y 1
z 4
x 5 *
p 1
q 6
|
April 5th, 2005 11:17 AM
by JulieD
|
5 |
174 |
|
|
Application prefix or not by
Rob
when creating some code, via the record macro function I find that
sometimes, for it to run succesfully, I need to add "Application"
immediately before some of...
|
April 5th, 2005 11:39 AM
by Rob
|
2 |
66 |
|
|
Macro for checkbox by
es
I have compiled this makro. But the error message
is:Compile error invalid or unqualified reference and
CheckBoxes is highlighted.
Please help.
If...
|
|
1 |
100 |