Another problem. What happens when there is LESS than 144 rows of data? For
instance, there could be anywhere between 1 and 144 rows. With your formula,
I got it to work with 144 rows, but got an error with less than 144 rows of
data.
"Max" wrote:
.. Max, I tried your formula, but got a VALUE error.
That means your data in col B is unfortunately mixed
with text/error values besides numbers
You could replace the earlier criteria formula in D1 with this:
=IF(ISNUMBER(B1),B1+ROW()/10^10,"")
Copy down, and it should work fine
Success? Pl click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---