| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing blank cells from a column
I have a column of data with blank cells inbetween some of the information. I
would like to list this column of data on a separate worksheet, with the blank cells removed. Each blank cell in the column, will have data in other cells in the same row, so the whole row won't be blank. For example: Existing worksheet New Worksheet a a b b c c d d Unfortunately I have no experience of writing macros. Can anyone help at all. Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding blank cells | Excel Discussion (Misc queries) | |||
| Rank a column but not include some cells | Excel Discussion (Misc queries) | |||
| HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
| how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) | |||
Threaded Mode
