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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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

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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

Forum statistics

Threads
1,143,750
Messages
5,720,633
Members
422,294
Latest member
Gemini774

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
Top