Dll Not Found/Missing Error------Repair You Dll Errors : Troubleshooting:Automatic generate enrollment number in excel Error

Automatic generate enrollment number in excel

Respected solver,
I have an excel sheet on which I have three column as follows:-
    a                                           b                                         c                                 d
name                           date of admission                      branch                       enroll.
no
deepak anand                01-Jan-2011                          Kalka ji                   01/01/Jan/2011  (should be generated automatically)
Swati                                 01-Jan-2011                         Kalkaji                     01/02/Jan/2011 (should be generated automatically)
Karan                               30-Jan-2011                          Kalkaji                    01/03/Jan/2011 (should be generated automatically)
Abhimanyu                       31-Jan-2011                         G.Puri                     02/01/Jan/2011 (should be generated automatically)
Manish                             01-Feb-2011                          Kalkaji                    01/01/Feb/2011 (should be generated automatically)
Shubham                         19-Feb-2011                         G.Puri                     02/01/Feb/2011 (should be generated automatically)
and so on.
Enroll code = branch code/number of student of particular month/Month of admission/year of admission
01 is branch code, i.e.
kalkaji is first branch, and G.puri is 02nd branch
Now, what i want that enrollment no should generate automatically, is there any VBA code , function or formula?
pls help
regards.
Ayushman

Solutions to the Problem Automatic generate enrollment number in excel

Download Error Fixer (Free)

Hi,
Your English is excellent, I can understand completely.
I produced this table

deepak anand
01-Jan-2011
Kalka
01/01/Jan2011

Swati
01-Jan-2011
Kalka
01/02/Jan2011

Karan
01-Jan-2011
Kalka
01/03/Jan2011

Abhimanyu
31-Jan-2011
G.Puri
02/01/Jan2011

Manish
01-Feb-2011
Kalka
01/01/Feb2011

Shubham
19-Feb-2011
G.Puri
02/01/Feb2011

The formula which goes in the bold cell (D1) is

=VLOOKUP(C1,$Q$1:$R$10,2,FALSE)&"/"&TEXT(SUMPRODUCT((--(TEXT($B$1:B1,"mmyyyy")=TEXT(B1,"mmyyyy"))*($C$1:C1=C1))),"00")&"/"&TEXT(B1,"mmmyyyy")

Note the leading zero comes from the table in columns Q & R where column R is formatted as TEXT and a leading zero added.

Kalka
01

G.Puri
02

me
03

You
04

Him
05

Her
06

Make Sure that your Computer Meets the System Requirements

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

This error can be due to some configuration requirements for you system. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Repair the Problem: Automatic generate enrollment number in excel:

How to Fix Automatic generate enrollment number in excel with SmartPCFixer?

1. Download Error Fixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.