| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range without Blank values
Hello:
i would appreciate help with the following I have a range (A1:A10) on Sheet1, with names of people. Some of the cells in this range are blank. On Sheet2, I want to populate the column A (from A1 downward) with the list of names from Sheet1, range (A1:A10) but without any blank cells. Thus for example if on Sheet1, in range A1 to A10 if only cells, A3, A8 & A10 have names & other cells in range A1:A10 are blank, then on Sheet2, I would like cells A1, A2, A3 to have the values of A3, A8 & A10 from sheet1 TIA Vinay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine and display values in range in 1 cell but skip blank cells | Excel Worksheet Functions | |||
| Need blank if no values in range getting value at the mo' | Excel Worksheet Functions | |||
| Count Non-Blank Values in a Table but only for a range | Excel Worksheet Functions | |||
| Sum of unique values within a range with blank cells | Excel Worksheet Functions | |||
| Creating a new worksheet by checking for blank values in a range | Excel Programming | |||
Threaded Mode
