|
|
|
|
4 |
1,001 |
|
|
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 |
1,000 |
|
|
Open.text macro fn syntax by
cuckoonuck
I have a FoxPro application which uses DDE to open a text file in Excel
and save it as a spreadsheet. I can open the text file with the
OPEN.TXT macro...
|
|
1 |
998 |
|
|
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 |
997 |
|
|
|
May 31st, 2010 06:54 AM
by Max
|
2 |
993 |
|
|
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 |
991 |
|
|
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 |
989 |
|
|
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 |
987 |
|
|
|
|
3 |
983 |
|
|
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 |
|
|
|
|
13 |
981 |
|
|
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 |
980 |
|
|
|
|
1 |
980 |
|
|
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 |
979 |
|
|
|
|
5 |
977 |
|
|
Formula to pull the lowest supplier name by
Cassius
I need assistance creating a formula to extract the supplier name associated
with the lowest supplier bid. A sample of the data looks like this. I need
to...
|
|
3 |
977 |
|
|
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 |
976 |
|
|
|
|
1 |
975 |
|
|
HLookup? by
wagz
I have a sheet that is comparing vendor's pricing. I am using the MIN to
find the cheapest cost, but now I want to find out which vendor it is based
on the...
|
|
2 |
975 |
|
|
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 |
975 |