|
|
Count number of instances by
Curtis[_6_]
Need a formaula to look at an entire column and count the number of
different times (say date of product)
Thanks
--
ce
|
|
4 |
879 |
|
|
|
|
2 |
893 |
|
|
Troubleshoot by
rwtrader
Can someone help me with the following statement:
=AVERAGEIFS(BeezidTable,BeezidTable,"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))")
It returns DIV/0, but...
|
|
2 |
748 |
|
|
Import old dos sequencial data by
Rich Stone
I have an old database that stored it's data in a sequencial format with
fixed lengths for each field. As Windows 7 64-bit no longer allows the
running of...
|
|
3 |
957 |
|
|
How to make a conditional Median function? by
myra_deV
for my thesis i need to create median industry multipliers. i have a list of
companies with their industry codes and multiples, but now i need to create a
list...
( 1 2)
|
|
16 |
1,897 |
|
|
|
|
1 |
929 |
|
|
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 |
968 |
|
|
MEDIANIF by
rwtrader
Was this function removed from 2007 or do I just need to download an add-in?
|
|
1 |
1,131 |
|
|
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 |
974 |
|
|
Average If by
carl
Is it possible to compute an average given a criteria.
For example, I have some data like this:
30 Day High30 Day...
|
|
3 |
867 |
|
|
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 |
966 |
|
|
How to give a string of data into different columns by
Elton Law[_2_]
Super expert,
If I have cell containing a series of data like this ....
1,12,9
1,2,9
1,22,17,18
23,23,1,9
24,21,1
1,23,11
|
|
8 |
1,202 |
|
|
|
|
5 |
907 |
|
|
lookup function by
Keith[_22_]
I have a column listing numbers in worksheet B. I'm looking for a formula
to place in worksheet A that will list the bottom number listed in that
worksheet...
|
|
4 |
903 |
|
|
SumIf and vlookup formula help by
Nikki
I have 5 categories that I need to sum but it is on another tab. I can't
remember how to use the Sumif and vlookup formula together.
Product A = 100
Product...
|
|
2 |
1,086 |
|
|
Import external data by
nordiyu
Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data...
|
June 4th, 2010 09:49 AM
by FSt1
|
6 |
853 |
|
|
Pre-configuring Pivot table "views" by
Mahurshi Akilla
I need to create several different pivot tables from the same set of
data. However, I need to keep switching between the different tables
and it quickly...
|
|
4 |
1,163 |
|
|
Pivot table in Excel 2007 by
Dinesh
Hi,
Somehow my Pivot table do not sums up by rows.
Boxes are checked for both columns and rows for Grand total under options,
Tools and Filter.
Dinesh
|
|
1 |
1,045 |
|
|
|
June 4th, 2010 12:55 AM
by Nadine
|
1 |
885 |
|
|
|
|
1 |
1,036 |