Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condensing Rows Automatically
Hello all.
I'm trying to condense rows on an Excel sheet to remove blank lines. I need to to pull two columns worth of information from another sheet first, this will create some blank rows. After I pull these rows I want to remove the blank lines such that the page will print nicely. A problem I fear is that the page that contains the blanks lines uses formulas to pull the information. E.g. Bob 12 Sam 11 Ted 10 Sue 9 Red 8 Would become: Bob 12 Sam 11 Ted 10 Sue 9 Red 8 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
condensing an email list | Excel Discussion (Misc queries) | |||
Condensing Formula | Excel Discussion (Misc queries) | |||
Condensing my worksheet | Excel Worksheet Functions | |||
Condensing lists | Excel Worksheet Functions | |||
condensing information onto one worksheet | Excel Worksheet Functions |