| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Columns with missing data that needs filled in
Got to work thanks so much.
Jannie "Gord Dibben" wrote: Select column A then F5SpecialBlanksOK Enter an = sign in active blank cell then point or arrow to cell above. Hit CTRL + ENTER. Copy column A and in place Paste SpecialValuesOKEsc. Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 10:52:00 -0700, Jannie worksheet function <Jannie worksheet wrote: I have a worksheet with thousands of rows of data. One column has data as shown below. Notice the blank lines. What I need is a formula that would make the data look like the column I show next to it. I know iI have seen this written before but I can't remember the formula to do it. Please Help. Thx. Jannie 10 10 10 10 10 12 12 52 52 60 60 60 60 40 40 40 20 20 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select filled region only in non-adjacent columns | Excel Discussion (Misc queries) | |||
| identify missing data b/t columns and then paste in anthoer column | Excel Discussion (Misc queries) | |||
| How to sort/synchronise 2 data columns with missing records? | Excel Discussion (Misc queries) | |||
| Copy Data From Filled to Empty Cells | Excel Discussion (Misc queries) | |||
| Checking if a cell is filled up with data | Excel Discussion (Misc queries) | |||
![Jannie worksheet function[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
