Getting rid of the blanks

nick m

New Member
Joined
Sep 27, 2002
Messages
14
Good evening all.
I have a spread sheet that opens another file, sort's data and searches for duplicate data. It then lists the duplicated data in another colum on another sheet. My problem is I cannot remember ( after late nights and some alchohol) how to get rid of the blanks to leave a polished report that is not full of holes. I am begining to unplug my pc ready for the window !
Pleae help I know it is a simple thing but i am tired.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-10-06 16:24, nick m wrote:
Good evening all.
I have a spread sheet that opens another file, sort's data and searches for duplicate data. It then lists the duplicated data in another colum on another sheet. My problem is I cannot remember ( after late nights and some alchohol) how to get rid of the blanks to leave a polished report that is not full of holes. I am begining to unplug my pc ready for the window !
Pleae help I know it is a simple thing but i am tired.

A macro would probably be more appropriate... but see my contrib with figures in:

http://www.mrexcel.com/board/viewtopic.php?topic=24204&forum=2&5
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi nick m:

If I have understood you correctly, you now have a final list that has some blank rows in it. If this is the case, you can highlite the list (with blanks), then DATA|FILTER|AutoFilter -- Blanks ...

at this point only blank entries will show up -- you can delete these rows ...

and what remains is your original list with the blank rows deleted.

I hope this does it for you -- if not explain a little further and let us take it from there.

Regards!

Yogi
This message was edited by Yogi Anand on 2002-10-06 17:03
 

Forum statistics

Threads
1,144,050
Messages
5,722,234
Members
422,417
Latest member
Johhny

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