Hi
Thank you, this works very fine for the ones who only comes in once a month.
But will I be able to maybe combinate this formular with another, so that I
can get all four numbers...like : A32=14 A33=22 A34=28 A35=30 If Anne comes
in from 14th may to 22nd may, and the she comes again from 28th may to the
30th. As it is for now, A32=14 and A33=30 in the above example.
Therese

"Max" wrote:

Perhaps something simple like this ?
(it assumes you have numbers as per your ps within row 2 to row 31)

In A32: =MIN(A2:A31)
In A33: =MAX(A2:A32)
Select A32:A33, copy across as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Therese" wrote:
Well....the numbers changes downwards.
We have a rather large list of names and the numbers varies from name to
name...The persons comes in different days in the month. Clara comes from the
14th to the 19th, Dora from th 12th to the 13th etc.
Some comes in twice, but that may be too dificult, don't you think?
Do you think you can work it out ?

Ps. They are just numbers. The worksheet is called may.

Thanks
Therese