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?

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...


--
John C


"PAL" wrote:

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?

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" wrote:

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...


--
John C


"PAL" wrote:

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?

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?
--
John C


"PAL" wrote:

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" wrote:

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...


--
John C


"PAL" wrote:

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?

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

"John C" wrote:

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?
--
John C


"PAL" wrote:

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" wrote:

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...


--
John C


"PAL" wrote:

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?