|
|
Average by Date by
inta251 via OfficeKB.com
Workbook containing two sheets
Sheet1 = trips
Some cells in ColumnB is blank (0)
ColumnA ColumnB
Mon, Jan 08, 2007
Mon, Jan 08, 2007 ...
( 1 2 3)
|
|
24 |
304 |
|
|
|
|
24 |
342 |
|
|
|
March 6th, 2007 05:35 PM
by wizman
|
24 |
258 |
|
|
Average If (Value between 1 and 100) by
DAI
Hello,
I need to show the average of a column (cells M8 to m5000)
As this column is populated by a formula =(L8/H8)*100
And in turn this is populated by the...
( 1 2 3)
|
November 28th, 2006 12:27 AM
by driller
|
24 |
170 |
|
|
eliminating matched records! by
via135 via OfficeKB.com
hi!
sorry..the data in my earlier post
was wrong and the correct one is
as follows:
i'm having some id in colA
& numbers (may be "+" or "-") in colB
as...
( 1 2 3)
|
|
24 |
339 |
|
|
[OT] posting by
tomek gomek
Hi.
I started read this group recently.
I have one stupid question :)
Why reply is almost always above message with question instead of under it?
Is this a...
( 1 2 3)
|
|
24 |
183 |
|
|
|
|
24 |
260 |
|
|
How do I sum up random cells by
Josh W
I want to add up the values of various discontiguous cells in a worksheet
e.g. A2+A7+C4+D7+G3. What is the quickest way to do this? The autosum
function...
( 1 2 3)
|
|
24 |
314 |
|
|
General Excel question by
dolpandotcom
I have two columns in an excel sheet. One column shows 1 representing male
and 2 represnting female. In the second column I have marks scored by males
and...
( 1 2 3)
|
|
24 |
471 |
|
|
Macro?? by
Connie Martin
I'm sure this can be done. Excel can do just about anything. Only wish I
could!! My spreadsheet has dates in Col. A, which are formatted as Date.
Each...
( 1 2 3)
|
|
24 |
242 |
|
|
Extracting a numbers from a text string by
IPerlovsky
How would I extract a number (or series of numbers) using a single cell
formula from an alphanumeric text string that also contains spaces? One key
component...
( 1 2 3)
|
|
24 |
186 |
|
|
|
|
23 |
234 |
|
|
Compute Tax? by
FeDude
This must have been done before, but for the life of me I cannot figure out
how (for a cell that contains taxable income), to compute federal income
taxes from...
( 1 2 3)
|
|
23 |
425 |
|
|
|
|
23 |
256 |
|
|
Find data in one table from another. by
micmed
I am reposting this to see if I can get another answer.
I need a formula that will allow me to search a column (B1:B19989) that
contains text with the data...
( 1 2 3)
|
|
23 |
300 |
|
|
|
|
23 |
1,332 |
|
|
Urgent help needed! by
skarbanan
I have tjis problem that is killing me.
I have this:
DATE | USER | CAR
------------------
5.1.2005 | MARK | LINCOLN
6.1.2005 | JOHN | LINCOLN
8.1.2005 | JOHN...
( 1 2 3)
|
December 30th, 2005 10:56 PM
by Biff
|
23 |
330 |
|
|
|
December 11th, 2005 04:06 PM
by Mike H
|
23 |
274 |
|
|
Counting cells by
Bob
Hello Group -
I'm trying to count the number of cells that contain the
word "walk".
Walk
Walk this way
Walking in the sand
To walk away
Let's take a walk
( 1 2 3)
|
|
23 |
323 |
|
|
countifs by
Trev
I need a formula that counts if column C = Sold, and column A = Name and
column S and be either New* or Under*
=COUNTIFS(C:C,"sold",A:A,"name")can equal Name...
( 1 2 3)
|
|
23 |
262 |