copy column w/data but delete empty cells

[imported_unknown]

I want to take the averages in cells at C:32 C:62 C:93 etc... and move that data into cells E:1 E:2 E:3 etc....

So I have 4 columns.
A column format: month/day/year
B column format: data (a number)
C column format: last day of month does a =Average(cellsformonth)
D column: Month names
E column format: want averages from 3rd column single spaced.

 

[plettieri]

I am sure your task is easy enough to but it might make more sense to give a short example of what yr data is and the expected outcome you want to see....see colo's utility program below to post up to the board.


pll

 

[imported_unknown]

yea I tried the utility but it says: "Could not load an object because it is not available on this machine."

I have these as items in column A:
| A |
|000|
|000|
|000|
|333|
|000|
|222|
|000|
|111|

I want this in column B:
| B |
|333|
|222|
|111|

So, my sheet would look like:
| A | B |
|000|333|
|000|222|
|000|111|
|333|
|000|
|222|
|000|
|111|
This message was edited by eaadams on 2002-10-02 19:24
This message was edited by eaadams on 2002-10-02 19:24
This message was edited by eaadams on 2002-10-02 19:26

 

[Yogi Anand]

Hi eaadams:

Welcome to the Board!

You can use Data Filter to accomplish this. See the worksheet simulation ...

y021002.xls
	A	B	C	D	E	F	G	H
1	Number		Number		Number			sourcedata
2	0		>0		333			criterion
3	0				222			filtereddata
4	0				111
5	333							UsingDATA|FILTER|AdvancedFilter
6	0
7	222
8	0
9	111
10
Sheet4

</SPAN>

Regards!

Yogi