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?

How do I loop a range of cells until I get a numeric value?
 

try put this in F1 (if free!)

=IF(ISNUMBER(B1);B1;"")


Mark F1, klick on lower right corner of the cell marker and pull (copy)
down until where ur data ends

Then hit the copy-icon, mark D1, then hit paste-icon-arrow and
select Values, then (maby) select data/sort

erase column F

do the same for kolumn C to F then back to E

"ManKind" skrev:

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?