Or if the OP wanted the results to be updated when the data changed.

Max wrote:

You're welcome !

.. but it seems that Dave's is very simple!
Thought you wanted it automated (w/o using vba) <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"via135" wrote in
message ...

thks Dave, Ron & Max.!.!.!

all your suggestions worked nicely! but it seems that Dave's is very
simple!

--

Dave Peterson