Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-08-2019, 12:21 AM   #1
mohamedmatter
Newly Registered User
 
Join Date: Oct 2015
Posts: 81
Thanks: 21
Thanked 0 Times in 0 Posts
mohamedmatter is on a distinguished road
auto number with duplicate -first-last bench

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
Attached Files
File Type: xlsx SchoolDb.xlsx (11.3 KB, 11 views)

mohamedmatter is offline   Reply With Quote
Old 05-10-2019, 07:35 AM   #2
mohamedmatter
Newly Registered User
 
Join Date: Oct 2015
Posts: 81
Thanks: 21
Thanked 0 Times in 0 Posts
mohamedmatter is on a distinguished road
Re: auto number with duplicate -first-last bench

Does the question need clarification?
mohamedmatter is offline   Reply With Quote
Old 05-16-2019, 08:35 PM   #3
mohamedmatter
Newly Registered User
 
Join Date: Oct 2015
Posts: 81
Thanks: 21
Thanked 0 Times in 0 Posts
mohamedmatter is on a distinguished road
Re: modified auto number with duplicate -first-last bench

i draw lines to request
Attached Files
File Type: xlsx SchoolDb-v2.xlsx (20.7 KB, 6 views)

mohamedmatter is offline   Reply With Quote
Old 05-21-2019, 09:33 AM   #4
kilroyscarnival
Newly Registered User
 
Join Date: Mar 2002
Location: Orlando, Florida, USA
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
kilroyscarnival
Re: auto number with duplicate -first-last bench

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 is offline   Reply With Quote
Old 05-21-2019, 09:37 AM   #5
kilroyscarnival
Newly Registered User
 
Join Date: Mar 2002
Location: Orlando, Florida, USA
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
kilroyscarnival
Re: auto number with duplicate -first-last bench

To populate the answer to "First Bench in all school" and "last bench in all school",

For School 1
=MIN(D$3$10)
should yield the lowest number bench
=MAX(D$3$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?

kilroyscarnival is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto number, year, month number combination nrgbmwx5 Tables 10 11-20-2015 08:26 AM
Auto Number PK, change starting number? Ms Kathy General 7 12-29-2013 09:18 AM
[SOLVED] Appending Records with a desired auto number in a table with Auto Number El hombre Loco Tables 7 10-21-2013 11:13 AM
Auto increasing a number, depending on maximum number when condition is met dannewestis General 3 09-22-2006 10:00 AM
Query that result incremental number, with no Auto-Number alvaro_xav Queries 1 09-11-2006 07:51 AM




All times are GMT -8. The time now is 09:06 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World