|
|
Counting for frequency by
Roxana[_2_]
How can I count the frequency a piece of data occurs in an array? I am trying
to determine if a a set of data repeats itself and how many times it repeats...
|
|
2 |
131 |
|
|
|
|
3 |
215 |
|
|
Password protect cells by
Christobo
I would like to protect six to ten cells within excel. But the cell protected
by one can ont be accessed by another, i.e. - I need to allow for multiple
uses...
|
|
9 |
204 |
|
|
SumIf AND by
NoodNutt
Hi everyone
I use the SumIF() usually to great effect, but this one has the grey matter
throbbing.
=SUMIF(Data!$P:P,"On Time",Data!O:O)
This returns the...
|
|
6 |
166 |
|
|
count similar text with using filters by
mj
I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still...
|
|
1 |
137 |
|
|
Match - not sure how to use this function by
Luvable Lady
I have created a Validation List called Suppliers, and then once I have
picked a supplier I want it to pull over the correct Account Code. An
example of the...
|
|
3 |
112 |
|
|
|
|
1 |
117 |
|
|
|
May 5th, 2010 12:31 PM
by Tola
|
3 |
310 |
|
|
|
|
4 |
180 |
|
|
About Data Validation by
moonhkt
Hi All
I have excel worksheet using Data Validation for control input Value.
In the raw data sheet, Define some Name e.g. "DBNAME", AREA","TABLE
Name"...
|
|
2 |
164 |
|
|
formula for month that is prior to actual by
GoBonnieGo
I saw a question with this title on here and it's exactly what I want... but
the answer is too technical for me and I'm wondering if someone can simplify
it....
|
|
6 |
133 |
|
|
inventory by
Gary
can you make a sum a text insted of a number
|
|
2 |
188 |
|
|
Regression Formula by
Abby
I'm trying to understand the Regression function- would someone be able to
explain the steps to calculate Regression and the info the formula generates?...
|
|
1 |
97 |
|
|
Counting results of a formula by
Nadine
I have a column that has about 111 rows to it. In each row is a formula that
will find an invoice number if it exists elsewhere. The are alpha-numeric...
|
May 5th, 2010 01:07 AM
by Nadine
|
9 |
190 |
|
|
|
|
0 |
88 |
|
|
Count blanks by date by
Molasses26
I have a table that has meter# , date, and usage in colums A, B and C.
I use a formula =sumif($B$11:$B1000,"=",$C$11:$C1000) to total up the
amount of usage...
|
May 5th, 2010 12:09 AM
by Max
|
2 |
96 |
|
|
|
|
2 |
110 |
|
|
lookup? by
Mezani
I am trying to enter data in sheet 1, that is dependant on drop down lists
that are on sheet 2, which is looking through named ranges on sheet 3. Is
lookup...
|
|
1 |
77 |
|
|
|
|
1 |
147 |
|
|
LOOKUP formula when term may not be present by
MichaelRobert
How can I get LOOKUP to return a 'blank' value when a term is not found in
the Lookup arrray? At present, what is being returned is the next
alphabetical...
|
|
1 |
108 |