If you change this term:
ROW(F$1:F$5) in the earlier expression
to: ROW($1:$5)
that'll make it robust for your movement of the data series in F1:F5 to
wherever
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:8ebba08d24c0e@uwe...
Dear Max,

Many thanks for your advice and suggested formula, it works very well.
However, I found one thing which I don't really understand. The suggested
formula will give me the result as : 1, 12 & 0 after I moved the whole
series
of data (20, 7, 1, 12 and 8) one cell downward (it means the series data
starting from F2). After I study the formular, I found that the result
back
to 7, 1 & 8 after I revised the range in the formular ROWS starting
from 1.
I don't understand why it will happen? Is that any way I can revise the
suggested formula even though I move the set data from F1 to F10?

Many thanks,
Wilchong