Creating a Registration form for classes that can assign "applicant number", "classes",etc

**tuneski** · 11-02-2013, 10:40 PM

Noob at excel but I really need this. Please help me. I don't wanna lose what I have because of excel

I need to make a registration form for some academic classes. There will be a total of 10 classes, 5 for class A (as in time/AM) and 5 for class B (PM). Max number of students per class is 20. The registration system should be able to assign a student number for every person that applies, and they can apply to at least one class and at most two classes. And as a summary thing, the file should be able to show how many people are in a class already and how many more slots are open to applicants. There also needs to be a report that can be printed that will contain the applicant's name, applicant number, the class/es the person enrolled in (and the classroom and moderator but that's up to me)

Please help me with the formulas, like just show me what formulas I can use. Really having a hard time here.

(If i did anything wrong or banned here pls just tell me, new member here)

Really really need help!

Thanks in advance!

**Jarko28** · 11-02-2013, 11:08 PM

upload a sample file with anonymous data and someone can take a look at it...

**tuneski** · 11-02-2013, 11:49 PM

I would, if I could start at all. I really really really don't know where to start.

If what you mean by anonymous data is like the name of the classes etc etc, then any placeholder can count. All I need are the formulas and stuff anyways.

Thanks though!

**Jarko28** · 11-03-2013, 11:43 AM

OK,

How about using the following functions as a start:

row - could be used to assign student number
counta - could be used to count number of students in a class

**tuneski** · 11-04-2013, 08:57 AM

^^ Thanks for suggesting the ROW function, got it working, I think. I didn't try COUNTA, I don't get it haha.

**Jarko28** · 11-04-2013, 11:28 AM

Counta is fairly simple:

It counts the amount of non blank cells in a range.

Say people sign up for a class, you can out their name on a list ...so for class 1 you can have a list of people in range A1:A20.

In a blank cell put in
=counta(A1:A20)

This will count the number of people already registered for class 1....

You wanted to see how many spots are still available....so I would suggest a formula like this:

=20-(counta(A1:A20))

Creating a Registration form for classes that can assign "applicant number", "classes",etc

LinkBack

Thread Tools

Rate This Thread

Display

Creating a Registration form for classes that can assign "applicant number", "classes",etc

Re: Simple formulas (more or less for noobs at excel) for a simple registration form. help

Re: Simple formulas (more or less for noobs at excel) for a simple registration form. help

Re: Creating a Registration form for classes that can assign "applicant number", "classes"

Re: Creating a Registration form for classes that can assign "applicant number", "classes"

Re: Creating a Registration form for classes that can assign "applicant number", "classes"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copying Excel formulas down... should be simple.

[SOLVED] Simple question about FORM / SAVE & EXCEL

[SOLVED] Simple Simple Excel usage question

Simple formulas in existing Excel 2002 no longer working.

Posting data from a simple form to a simple database

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions