|
|
|
|
1 |
82 |
|
|
CountIF by
John
I am trying to make excel count the number of cells that have a certain
criteria. Lets say that I want it to count how many of the cells in a list
say...
|
June 17th, 2008 09:56 PM
by mjmeyer
|
3 |
80 |
|
|
Disbaling Error in formula notification by
Sandeep Singh
Hi,
How can I disable the display of "####" in a cell whenever a formula has
errors?
I am using formula's to populate the sheet2 depending on the values...
|
June 17th, 2008 09:50 PM
by Spiky
|
5 |
93 |
|
|
|
June 17th, 2008 09:47 PM
by Marc
|
3 |
87 |
|
|
copying a row by
james b
Hi
can anyone help?? i have a speadsheet that has 5 headings, name, save rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet if in...
|
|
6 |
95 |
|
|
Filter for unique value by
Christi Witte
I have 2 sets of data that should be identical but I know they are not - how
can I filter so that it gives me only the unique values? I have found ways
of...
|
June 17th, 2008 09:33 PM
by Spiky
|
3 |
121 |
|
|
Find text, then calculate by
Teatro
I have a spreadsheet that has 3 sizes in a text string in cells. For example,
A2 may have 1 Gal, A3 may have 1 Qt and A4 may have 5 Gal.
I want to create an...
|
June 17th, 2008 09:14 PM
by Teatro
|
6 |
73 |
|
|
|
|
1 |
91 |
|
|
lock command button by
jan
hi,
i would need to lock a command button so when i protect a worksheet it is
locked. any good suggestions?
thanks
|
June 17th, 2008 08:38 PM
by jan
|
0 |
68 |
|
|
SUMIF [sum_range] / sorting question by
jiml
Suppose I have data that looks like:
1/1/2008 1/3/2008 2/7/2008
Ordered Ordered Ordered
Aardvarks 8 7 3
Baboons 3 10 7
Cats 5 3 2
Ducks 5 1 7
Elephants 7 2 8
|
June 17th, 2008 08:31 PM
by Spiky
|
4 |
72 |
|
|
How do I conditionally hide a worksheet by
Jeremehovah
I would like to have different worksheet tabs that are only viewable based on
answers given on a main page. Say I have 4 conditional pages, based on 1 of
4...
|
|
1 |
76 |
|
|
Finding Zeros by
Seahorsenerd
Hey,
I have a speadsheet with a bunch of numbers in Column B From B3 to B367 and
i want to find the number that is closest to zero. (Numbers are rounded off...
|
|
2 |
59 |
|
|
Counting date occurances by
Kim
I have two columns P and R that contain both date information and numbers. I
want to count everytime a date is entered in the cell. Example...
|
June 17th, 2008 07:29 PM
by Mike H
|
3 |
61 |
|
|
|
|
7 |
93 |
|
|
|
June 17th, 2008 06:27 PM
by Brian
|
0 |
85 |
|
|
|
|
3 |
74 |
|
|
|
|
7 |
89 |
|
|
Adding Random Numbers by
Gary''s Student
I need to add up 23 independent random numbers. My first try was:
=RAND()*23
This proved to be insufficient since it really only added the same random...
( 1 2 3)
|
|
23 |
246 |
|
|
if isblank question by
TamIam
Good day,
Would anyone know of a way to include the if(isblank()) in reference to a
column with every fourth cell populated with a value that needs to be...
|
|
5 |
107 |
|
|
Count Longest Consecutive Sequence of zeros by
Sam via OfficeKB.com
Hi All,
I have a single column, dynamic named range called "Data" that contains
numeric values.
Is it possible without the use of a helper column (or other...
( 1 2)
|
|
12 |
209 |