|
|
SUMPRODUCT??? by
Ket
Hello,
I have looked through the threads and believe what I require is the
SUMPRODUCT function.
I have a spreadsheet with column A containing dates in the...
|
|
3 |
87 |
|
|
|
|
3 |
252 |
|
|
count cells with unique numbers by
Alex
If I have a column with some repeated numbers:
58
168
168
25
....
How could I count the cells from the column to get 3 (not 4) as a result -
to be able to...
|
|
1 |
239 |
|
|
Count in Pivot Table by
waxwing
I need a formula to count the number of records meeting a criteria in a
pivot table. Since the column in the pivot table that contains the
data to look at may...
|
|
5 |
171 |
|
|
Vlookup from 2 different sheets by
WorkerBee
I would like my vlookup function to look for a value in one sheet and if it
doesn't find it, look in another sheet. Is this possible?
I was considering using...
( 1 2 3)
|
|
20 |
477 |
|
|
|
|
1 |
207 |
|
|
|
|
3 |
238 |
|
|
count by
d sweeney
I am trying to count two colums if they both meet/match a curtain number.
Example if A1 = 2 and B1 = 12 then add one to the count.
The array that I am trying...
|
|
2 |
97 |
|
|
|
|
2 |
139 |
|
|
Last in column formula by
EAN
I'm trying to get a formula result to return the value in the last filled row
of a column on a worksheet in another book. I've used "LASTINCOLUMN" before,
but...
|
February 21st, 2005 09:35 PM
by EAN
|
3 |
94 |
|
|
sumif by
choice
column A non unique dates in ascending order
column C either a value greater then zero or blank
column N either "upgrade" or blank
column R a number
I need to...
|
|
4 |
122 |
|
|
|
February 21st, 2005 09:59 PM
by jv
|
7 |
117 |
|
|
|
February 21st, 2005 10:13 PM
by Sampson
|
3 |
442 |
|
|
pivot table by
yllee70
Would appreciate any form of help. After setting up a pivot table (in a
separate worksheet from the data sheet), I copied and pasted that first pivot
table a...
|
|
1 |
219 |
|
|
reports by
herbzee
How do I make a report in Excel? I'm so accustomed to doing it in Works
4.5 and its easy there, but I need it in Excel. Is there a tutorial I
can d/l? thanx.
|
|
1 |
61 |
|
|
|
February 21st, 2005 10:57 PM
by happy
|
0 |
79 |
|
|
|
February 21st, 2005 10:59 PM
by Suz
|
4 |
238 |
|
|
|
|
2 |
84 |
|
|
|
|
5 |
237 |
|
|
Parsing a column by
chulita
Given a data base with first & last names in one column. How do alphabetize
with last names first, and first names last?
|
|
1 |
80 |