|
|
New drop down menu by
pcor
A long time ago I had some code to add a drop down menu to Excel. Can some
kind soul please direct me to a location where I can recapture that
code.\Thanks
|
|
3 |
170 |
|
|
Formula? by
newby1273
Here is what I want to do:
If a cell (formatted as number) is between 0 and 10 multiply it by this. If
it's between 10 and 20 multiply it by that. How do...
|
May 1st, 2008 07:11 PM
by Brad
|
7 |
113 |
|
|
Figure out 24 hour staffing data by
excel moron
I am trying to create a 24-hour staffing schedule but I cannot figure out how
to automate the process.
There are 7 overlapping 12-hour shifts with two work...
|
|
3 |
358 |
|
|
|
|
1 |
137 |
|
|
Adding rows of data based on first column by
Dewaynep
Not sure if I worded that correctly. Here's what I need to do: I have sales
data for a month that is listed individually by date and item number. I need
to...
|
|
3 |
115 |
|
|
Check if content in cell is an integer by
prem
How do I check if the content in a cell, when divided by 4, returns an
integer? It should give me 150 if it is an integer and display "NA" if it is
not an...
|
|
6 |
191 |
|
|
Excell by
Shiblie Bshara
Dear All,
I need an automatic formula or a format that give's me the ability to enter
these numbers (Handling Time) as (HH:MM)
but to be converted to...
|
|
1 |
76 |
|
|
|
|
2 |
132 |
|
|
Check if content in cell is an integer by
Mike H
Try this
=IF(MOD(A2,4)=0,"Integer","No an integer")
Mike
"prem" wrote:
How do I check if the content in a cell, when divided by 4, returns an
integer?...
|
May 1st, 2008 09:53 AM
by Mike H
|
0 |
78 |
|
|
Excel Viewer 2003 Problem by
Michael Gerbasio
Hi,
I'm a a co-worker sending me spreadsheets that are created in alother
program and saved as Excel files. I have no problem opening these in MS
Excel 2003...
|
|
6 |
175 |
|
|
Where do I find the commands for a macro by
Pat
I recorded a macro to input a number, move right 3 spaces, enter a number,
ect .......
when I recorded it I intended to go back and replace the numbers I put...
|
|
9 |
113 |
|
|
Changing & Saving Fonts by
EmperorSonny
When I change the default font in a new Excel Worksheet I seem to have to
change it inn each cel individually. How can I do this more efficiently.
|
|
1 |
100 |
|
|
Protecting formulas in workbook by
Lynne Mawson
I'm very new to Excel and have taken a long time to work out some formulas in
a workbook. This book is shared by people who have little or no knowledge at...
|
April 30th, 2008 07:11 PM
by Dave
|
2 |
127 |
|
|
Excel 2007 will not save Recent Documents by
Gren
A newly installed version of Excel 2007 does not show any recent documents
after restart even when I have used the pushpins. Any one have any ideas
please?...
|
|
3 |
144 |
|
|
|
|
1 |
104 |
|
|
Failure rate by
Frank[_15_]
Hi,
Is there a formula to calculate failure rates in excel? I have a life
expectancy, age of equipment, and failures in a year and would like to have
a...
|
|
1 |
118 |
|
|
Mail merge formating by
pcor
One of the MVP providing very good help here has just what I am looking for...
I am looking for the code to place in a mergedfield to show dollars & cents
as...
|
|
2 |
118 |
|
|
reposition user form by
Chad
Hello, I have a user form that named Splash_Form and I want to make it so it
cant be moved around the screen. I want it to stay in one spot in the center....
|
April 29th, 2008 09:49 PM
by Chad
|
0 |
97 |
|
|
Simple (I bet) Newbie question... by
Edward
I hope this is possible to have happen all in 1 formula
How can i compose a formula that would acheive the following:
If the number in J5 is at least...
|
April 29th, 2008 09:08 PM
by Edward
|
2 |
84 |
|
|
|
|
1 |
107 |