|
|
changing a button color by
amy
Hi.
I have excel 2000 and I'm trying to change the color of a
button that I have on a form, that is assigned to a
particular macro, but on the format control...
|
|
2 |
664 |
|
|
|
|
3 |
92 |
|
|
|
Nested Ifs by
Amy
Hi all,
I have used Chip Pearsons work around for nested ifs. I have named my 6
separate formulas All1 - All6. But the 'Master' formula does not seem to...
|
October 9th, 2006 01:54 AM
by Amy 
|
3 |
61 |
|
|
|
CUSUM and V-Mask by
Amy
Does anyone know if Excel is capable of doing a V-Mask for a CUSUM?
|
|
1 |
72 |
|
|
|
Total Time Worked - How to Calculate by
Amy
Hello - I am new to the Office Discussion Groups and am despartely looking
for some help.
I have data from a time management system that reports start time...
|
February 28th, 2007 08:01 PM
by Amy
|
2 |
70 |
|
|
|
Using Subtotaled Data by
Amy
I have many rows of daily data by employee. For example, at the minimum,
there will be 2 rows of data per employee by day for over 5000 employees. I
have...
|
|
3 |
44 |
|
|
|
Formatting in Forms by
Amy
Can you set a forced format within forms? (i.e. state = 2 alpha, capital)
When someone enters ca it will change to CA or title case verses caps for
data...
|
March 8th, 2007 08:32 PM
by Amy
|
2 |
45 |
|
|
|
|
|
1 |
63 |
|
|
|
Excel if Functions by
Amy
I am working on a payrol tracking worsheet. I have everything right but one
step. I need the function not to calculate overtime if there is an amount in
the...
|
|
1 |
77 |
|
|
|
Sumproduct formula by
Amy
Can someone help with this formula?
I am trying to find out late shipments in a particular
time frame (DATE/YEAR)
The values for $Q$2 is 01/01/04 3:00 AM ...
|
|
1 |
242 |
|
|
|
How to remove Comma In name fornat by
amy
Need your help urgently.
I have the following name format:
Lee,Siew Lin and Aminah Binti,Ali
How to remove the comma and became the name format as
Lee Siew...
|
|
2 |
105 |
|
|
|
Trying to use functions by
Amy
I am trying to create a function and I am having
problems. I want to have like a countdown type of
function. I want to have todays date add a day until...
|
October 23rd, 2003 09:51 PM
by Amy
|
8 |
112 |
|
|
|
Grades by
Amy
what is the funtion to post a letter grade corresponding
with the percentage you receive
|
|
3 |
79 |
|
|
|
Show file creation date in header by
Amy
Happy New Year to all!
Is there any way that I can show the date that the file
was created in the header instead of the current date.
I've been using...
|
December 31st, 2003 07:56 PM
by
|
2 |
257 |
|
|
|
Comparing separate worksheets by
Amy
I am trying to compare two worksheets with this type of
data:
Last First Confirmation# Check-In Check-Out
The two lists need to be checked for...
|
January 15th, 2004 01:14 AM
by Max
|
1 |
168 |
|
|
|
Grades by
Amy
How do I create a function for keeping track of my grades
each time I get a new grade posted. For example am I
getting an A, B, etc. a certain percentage = A
|
|
3 |
88 |
|
|
|
dropping number by
amy
When I type 020627 excel puts in 20627 it always drops
the zero. I have tried differnet formats... what am I
doing wrong? thanks
|
|
3 |
125 |
|
|
|
Extra Pages in a sheet of the workbook by
Amy
Hello,
I am trying to remove extra pages from a sheet of the workbook I am working on. Everytime I go into pagebreak view I remove page two, three, four so...
|
July 8th, 2004 03:56 PM
by Andy B
|
1 |
138 |
|
|
|
How to take out comma (,) in name format by
amy
Need help urgently.
I have a name format, Lee,Siew Lin or Aminah Binti, Ali.
How can i remove the comma from the name format to
Lee Siew Lin or Aminah Binti...
|
|
2 |
104 |
|
|
|
Hlookup and sum noncontiguous numbers by
Amy
I need help with the following problem: I was using the nested if function,
but due to limitation of seven levels only, i need to find alternative
solution...
|
June 12th, 2008 02:58 AM
by Max
|
1 |
76 |
