copy column w/data but delete empty cells

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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
 
Upvote 0
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
 
Upvote 0
Hi eaadams:

Welcome to the Board!

You can use Data Filter to accomplish this. See the worksheet simulation ...
y021002.xls
ABCDEFGH
1NumberNumberNumbersourcedata
20>0333criterion
30222filtereddata
40111
5333UsingDATA|FILTER|AdvancedFilter
60
7222
80
9111
10
Sheet4
</SPAN>

Regards!

Yogi
 
Upvote 0

Forum statistics

Threads
1,218,628
Messages
6,143,589
Members
450,494
Latest member
GolfNut39

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top