Excel Data Copy

Closed
dangreen Posts 1 Registration date Sunday April 4, 2010 Status Member Last seen April 4, 2010 - Apr 4, 2010 at 01:34 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 5, 2010 at 11:33 AM
I am looking for a formula that does the following:
Looks at cell values in a particular column
If the cells have data it then copies that data to another column
If the cells have no data then it dows not copy them
So if the original column had say 20 cells, with only 3 of them containing data, (and the three cells werent together as there are gaps in between)
then the target column would only have 3 cells with values in them, and they would be at the top - with no spaces in between them.
Any thoughts? ? ":-)

3 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 4, 2010 at 11:33 AM
I loathe to say that it cannot be by formula only as I am sure some one would know how. But from my limited knowledge, I think this all can be done via macro very easily.
0
Thanks rizvisa1, yes sorry should have said macro - yes agreed shouldn't be a hard one - I just don't know the answer :-)
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 5, 2010 at 11:33 AM
come to think of it, you do not need any macro either. If you select that whole column and apply filter on that to show non blank, then copy it to the new location and paste special to skip blank values, you should get what you want
0