|
|
Randbetween help by
Tom
am using Excel 2003 and I have a formula to randomly select employees for a
mandatory drug screen. I have 15 employees and I use the formula...
|
|
2 |
97 |
|
|
|
May 20th, 2009 04:55 PM
by Pat
|
6 |
111 |
|
|
Separating data from cells by
Justin Case[_2_]
Hi Ed,
Are you referring to multiple sheets? Or are there multiple records in
the same row?
Justin
|
|
6 |
118 |
|
|
NESTED IF FORMULA - IGNORE BLANK CELLS by
Evan
I have a spreadsheet that is updated throughout the month and a column that
presents a summary of data entered-to-date. Is there a nested IF formula
that...
|
May 20th, 2009 04:32 PM
by Evan
|
5 |
119 |
|
|
calculating by
Kay
I need a formula to issue 1 day every four month starting with the month
already in a cell,
Can you help.
KK
|
May 20th, 2009 04:27 PM
by Kay
|
3 |
119 |
|
|
how to copy cell formatting in formula by
JBW
This is going to be easy peasy I know, but it's got me stumped.
I need to copy a cells contents and format (not conditional) into a
frontsheet.
Using simple...
|
|
5 |
93 |
|
|
COUntif AND... by
NWO
Hello.
I read all of the COUNTIF , AND threads but did not find a solution to my
problem.
- I have a column of dates on one worklsheet
- I'm trying to...
( 1 2)
|
|
10 |
210 |
|
|
|
|
3 |
98 |
|
|
If Cell Contains specific UPPERCASE text by
GoBucks
I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a...
|
|
4 |
111 |
|
|
Move data - what happens to formula's by
willemeulen[_22_]
Hi all,
I've been working on a nice spreadsheet for over a week, now that I'm
close to finalizing a nice looking sheet which will safe the colleques a
lot of...
|
|
2 |
109 |
|
|
format cells semi automatic by
willemeulen[_23_]
I was wondering if it would be possible to format cells semi automatic.
See attached picture for example.
I have a standard workbook to help collegues...
|
|
0 |
115 |
|
|
|
|
7 |
77 |
|
|
Rank and Sort by
watermt
I'm trying to sort the list below based upon the results displayed in the
last two columns. I tried to sort the data but it did not display what I was...
|
|
2 |
119 |
|
|
Macor Button Dissapears by
Gaffnr
Hi, Ive created a macro and assigned it to a button. when I run the macro,
it works perfectly, however, at completion of the macro, the button
dissapears. ...
|
|
1 |
108 |
|
|
lookup more than one value across a table by
Dee
i have a spreadsheet with 52 rows of data relating to properties, i.e. 52
properties. in column B i have the information to which office location it
belongs...
|
May 20th, 2009 02:23 PM
by Dee
|
4 |
73 |
|
|
How can I calculate the numbers? by
AP
Hi all
I'm busy capturing a staff survey.
I need to calculate the number of times the staff members answered "Agree,
Disagree, etc" to questions 1 - 26 from...
|
|
1 |
87 |
|
|
Password security by
Blue
Hi,
I have a macro for protecting sheets & the ability to run the macro is
password protected. Is there any way i can program it so that when i type in
the...
|
|
1 |
97 |
|
|
|
|
5 |
167 |
|
|
IF Function by
willemeulen[_19_]
Another IF challange.
I have the following formula (shematic):
A + B + 0,57C + D - 0,5r - 2,57d
Got the formula working nicely, even with the follwing...
|
|
2 |
92 |
|
|
CAN I HAVE TWO IF FUNCTIONS by
barry
I am using this formula
=IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=YES,F12/11,IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=MIXED,"ENTER",0))
in coulmn "g"...
|
|
1 |
142 |