|
|
Average Calculation by
smallcap
I have a set of data(numbers)like 1,60,50,50,44,24,10,15,13,5,15 in a
column.
Now, I have to calculate the average of ranges 0-10, 11-20, 21-30....
Please...
|
October 28th, 2005 12:36 AM
by RagDyer
|
6 |
119 |
|
|
|
|
20 |
280 |
|
|
Here's an EASY one for you, not me :( by
barbierim
OK I have zipcodes in column A (a1-a700) and I would like to put all
into B1 separated by a ",".
so that B1 will have 700 zipcodes all separated by a...
|
|
4 |
113 |
|
|
another interesting thing... by
Nick Dangr
Maybe there's an easy way to do this. A lot of my excel work revolves
around data pulled from a live database. I'll have variable length
tables. My current...
|
|
5 |
114 |
|
|
combo boxes by
martin
Hi
I'm trying to automaticaly select a certain cell depending on the results of
the combo boxes ie:
If combo box 1 has a list of names 1-10, and combo box 2...
|
October 28th, 2005 12:56 AM
by martin
|
0 |
81 |
|
|
Copy complete row by
Joel
I hav a large data there is a way of copy a complete row if certain values
are in the rows
|
|
1 |
89 |
|
|
adding amounts according to labels by
Wayne Cameron
I have labels in col D (multiple lines but only 7 different labels). I wish
to add the cells in col E into 7 seperate totals (according to label). This
is the...
|
October 28th, 2005 01:16 AM
by RagDyer
|
1 |
98 |
|
|
|
|
1 |
140 |
|
|
merging columns - one date, one time by
batfish
I am trying to merge two columns - one with the date and another with the
time so that eventually I can subtract two merged dated/time columns from
each other....
|
|
2 |
150 |
|
|
SUMPRODUCT question by
Lee Harris
Where does one find out in detail about this and other Excel functions
outside Excels own help
for example, I often see formulas such...
|
October 28th, 2005 04:06 AM
by JMB
|
4 |
107 |
|
|
Deleting links to other spreadsheets by
KarenH
I have a spreadsheet that apparently contains links to about 40 other
spreadsheets. Some of these spreadsheets then contain links to others.
There is no where...
|
October 28th, 2005 04:09 AM
by JMB
|
2 |
257 |
|
|
Something like CEILING or FLOOR by
gusvenables
Hi,
I am currently working on a project whereby I enter fractions of hours,
and they appear in cells as decimals. So, for example, if I want to
enter 10...
|
|
3 |
109 |
|
|
Fiancial Calendar by
garretts run kid
I am trying to create a finacial budget calendar. I would like to display
creditors, amount due & payment amounts on one sheet and then transpose it
into an...
|
|
1 |
79 |
|
|
conditional search by
ph2da00
Hi everyone. I've run into a bit of a problem with one of my
worksheets. I have a column whose cells are either blank, "Buy" or
"Sell" I want the column next...
|
October 28th, 2005 10:09 AM
by Stefi
|
2 |
67 |
|
|
What Formula Q by
John
I wish to create a formula that will return the text "Small Variance Is" if
the value of C10 is + OR- ?10, otherwise "Large Variance Is".
I know how to do it...
|
October 28th, 2005 10:14 AM
by John
|
2 |
70 |
|
|
Sumproduct and offset by
Maarten
Dear list,
I've got a table that looks like this (numbers on left side are row numbers):
1 S1 S2 S3 S4 S5
2 X1 1 0 1 1 1
3 X2 0 0 0 1 1
4 ...
|
|
4 |
175 |
|
|
|
|
1 |
152 |
|
|
|
|
1 |
185 |
|
|
Advanced Filters by
Louise
I have a worksheet containing various data, including staff names, their
start date and the department they work for.
I am trying to use an Advanced Filter...
|
October 28th, 2005 11:52 AM
by Louise
|
9 |
133 |
|
|
|
October 28th, 2005 12:54 PM
by Maco
|
2 |
200 |