Min +1

[PAL]

I am trying to figure out how to solve the following problem.

I am organizing a meeting at several sites where each site has many people.
Using the MIN function looking at the enrollment date I am able to determine
who signs up first.

What I would like to do is find out how long after the first person sign up
does it take the scond person, third person etc...


Any ideas?

 

[John C]

The first person to sign up would be
=SMALL($A$1:$A$20,1)

The second person to sign up would be:
=SMALL($A$1:$A$20,2)

Could start in row 1 and use the following formula copied down as needed:
=SMALL($A$1:$A$20,ROW())

Though, if this is based solely on date, you may have issues finding the
difference between 2 people who signed up on the same date...

 

[PAL]

Thanks and good point. There will undoubtably be people that signed up on
the same date. Is there anyway to insert a count of the number next to it.
It gets complex.......

 

[John C]

Well, your count of people is equal to the last ROW() with data. How are they
signing up? In a database? on paper? how is this data being entered into
excel?

 

[PAL]

Export from a much larger database that has many different meetings. This
solution would end up within an array.