|
|
|
|
2 |
224 |
|
|
Multiple condition data validation by
IanC
Is it possible to set up data validation to allow only numbers greater than
or equal to zero OR text equal to n/a.
I have check sheets for machine...
|
May 15th, 2010 08:26 AM
by IanC
|
3 |
193 |
|
|
|
|
2 |
184 |
|
|
|
|
3 |
210 |
|
|
Add across sheets by criteria by
sbrodginski
I have multiple sheets with 3 columns of data each. The first col is ID
info, the other two track hours and dollars, respectively. I want to add up
all the...
|
|
3 |
269 |
|
|
|
|
5 |
246 |
|
|
Need help with CountIF function by
Flo
Hello,
Please help. I have a columne A with department codes A, B, C, ... the
department codes are multiple lines, column B with numbers when there are...
|
|
2 |
160 |
|
|
#value! in linked document by
TamIam
Hi there, is there any way to automatically update linked documents without
opening the source document? When I leave them closed, my main worksheet
shows...
|
|
2 |
155 |
|
|
Column Lookup? by
Doug
I have reference data in Column "$Q$3:$Q$502" of "sheet1". For all cells in
the reference column that contain "yes", I would like to average quantity in...
|
|
3 |
173 |
|
|
Date and Time by
Jen_T
I have cells in a worksheet that are formatted as date but still show as date
and time. How do I pull out the time.
E.g.
04/07/2009 1:00:00 AM
I have tried...
|
|
8 |
226 |
|
|
conditional count by
TimW
Any simple way to count how many 1s and how many 2s here?
2
1
2
2
2
1
2
1
1
|
|
4 |
152 |
|
|
Question using countif by
Tim JA
I'm using office 2007, specifically excel. I cannot get the countif function
to accurately count cells containing multiple numbers. For example below is a...
( 1 2)
|
|
11 |
430 |
|
|
if-then functions by
Becky
I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx
|
|
2 |
172 |
|
|
Best 3 Consecutive Months by
Desoto
I have 10 years worth of monthly data and need to determine the best (or
worst) three consecutive months for benchmarking purposes. How do I write a
formula...
( 1 2)
|
|
13 |
330 |
|
|
COUNT FORMULA??? by
psd364
I need to use a formula to find out how many times the value in B2 appears in
column B.
|
|
6 |
202 |
|
|
|
|
1 |
165 |
|
|
|
|
2 |
205 |
|
|
|
|
3 |
257 |
|
|
|
|
7 |
246 |
|
|
Delete previous cell content by
Craig
Hi,
Not sure if this is function or programming?
Question is:
In column F, Row 4, Header is "Do You Require Training?" in row 5 is a
validation list = Yes,...
|
May 14th, 2010 09:06 PM
by Craig
|
2 |
150 |