| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I loop a range of cells until I get a numeric value?
I have two columns of sales data. Both columns have 156 weeks of data (three
years). The item in column B has NA data until Jan 2005. The item in column C has data from mid 2004. How do I loop through these columns, pick up only where the data starts from and paste only the sales data < NA into columns D and E? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
