auto number with duplicate -first-last bench (1 Viewer)

mohamedmatter

Registered User.
Local time
Today, 05:05
Joined
Oct 25, 2015
Messages
112
hello group
i attach sample schooldb
my request
1- Id-School without duplicate Id
2-Id-School duplicate Id to school
3-First bench and First bench in all school

many thanks
 

Attachments

  • SchoolDb.xlsx
    11.3 KB · Views: 169

mohamedmatter

Registered User.
Local time
Today, 05:05
Joined
Oct 25, 2015
Messages
112
Re: modified auto number with duplicate -first-last bench

i draw lines to request
 

Attachments

  • SchoolDb-v2.xlsx
    20.7 KB · Views: 149

kilroyscarnival

Registered User.
Local time
Today, 12:05
Joined
Mar 6, 2002
Messages
76
SECOND REQUEST column: You want to copy over the number from "First Request" (you'll want to check your spelling on "first", by the way).

The way I would do this with a formula is put your cursor in cell G3 and use:

=IF(F3="",G2,F3)

What this says is, if there's no number to the left of this cell, simply copy the cell above this one, but if there is data to the left, copy that. In this case it would copy the "1" over. If you fill this formula down the column it should work for you.
 

kilroyscarnival

Registered User.
Local time
Today, 12:05
Joined
Mar 6, 2002
Messages
76
To populate the answer to "First Bench in all school" and "last bench in all school",

For School 1
=MIN(D$3:D$10)
should yield the lowest number bench
=MAX(D$3:D$10)
should yield the highest number bench

But you'd need to redo the formula for each school and do they always have a consistent number of students/benches in them?
 

Users who are viewing this thread

Top Bottom