|
|
countif by
Jim W
I am trying to count the number of cells in column B="large" when the
condition in column A="week1". I tried the formula below and it counted all
the...
|
|
3 |
990 |
|
|
Transpose link by
Ana via OfficeKB.com
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
corner of a cell. I will automaticly link
A1 - C1
A2 - C2
A3 - C3 ect
My question is...
|
|
5 |
987 |
|
|
COUNTIF function for multiple criteria by
yorkshirelass
I hope someone can help me. I devised a s/sheet in Excel 2007 using the
COUNTIFS function. However, not all my colleagues like 2007 and have
reverted back to...
|
June 18th, 2009 01:45 PM
by Bernd P
|
8 |
987 |
|
|
Pivot from multiple sheets by
Radhakant Panigrahi
hi,
i have the below data and i need to make pivot from multiple sheets.i have
tried to make by selecting multiple consolidation ranges, bbut it is not...
|
|
1 |
984 |
|
|
|
|
3 |
982 |
|
|
Large list of numbers to concatenate by
MaggieB.
I have a list of 600+ zip codes that are curently in individual cells. I need
to turn them into one list separated by commas. Is this possible? The best...
|
|
3 |
981 |
|
|
Array Functions by
Alan Beban
To those, if any, who use the array functions in the freely downloadable
file at http://home.pacbell.net/beban:
I refreshed the file yesterday with changes I...
( 1 2)
|
|
11 |
981 |
|
|
|
|
1 |
980 |
|
|
|
|
13 |
980 |
|
|
|
May 31st, 2010 06:54 AM
by Max
|
2 |
978 |
|
|
Macro help - add column selection by
HeatherJ
I have the following replace info in a macro.
Selection.Replace What:="Of", Replacement:= _
" of ", LookAt:=xlPart, SearchOrder:=xlByRows, _
...
|
|
1 |
975 |
|
|
|
|
5 |
974 |
|
|
|
|
9 |
972 |
|
|
AMVERAGIF Condition by
rwtrader
I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this?
|
|
6 |
970 |
|
|
|
|
1 |
970 |
|
|
Count number of people by
burtlake
We will be hosting a large fund raiser. I need to know the number of people
attending. Here's my problem................
Some people come as couples, and...
|
|
4 |
970 |
|
|
time and attendance by
JGB
Has anyone used Excel to track employee time and attendance? We have a basic
worksheet set up, but are trying to determine if there is a specific way to
show...
|
January 25th, 2006 05:20 PM
by JGB
|
0 |
969 |
|
|
Multiple List function by
George
I have one list that contains general info. I made another
to list different columns value from first list for Data,
index and/or lookup functions.
Is there a...
|
|
8 |
968 |
|
|
sheet name in workshhetfunction by
Radhakant Panigrahi
Hi ,
I am using the sheet reference in a formula. the sheets are named on the
basis of dates of a month...
So i have to change the formula in every month...
|
May 31st, 2010 02:55 PM
by Mike H
|
2 |
968 |
|
|
Can't Edit Worksheet Comments by
Paul Calcagno
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.
All of a sudden only one (of many) worksheets...
|
|
1 |
968 |