Top 5 States With Values

Z

ZSchoonover

New Member
Joined
Sep 26, 2017
Messages
8
So I've been researching all day on how to do this, and I'm a bit confused on how to proceed. I need to create multiple top 5 list of States from a data series. I've included a screenshot to help better understand what it I'm trying to achieve. In short, I need excel to auto calculate the top 5 states for students who have applied for spring and fall semesters and return the state name next to the number itself. This info will be populated into 2 separate areas of the sheet C11:D15 and C35:D38. There will be duplicates included with this.

Capture_zps8vqdng8b.png
[/URL][/IMG]

The range L2:L51 is labeled "States", M2:M51 is "Spring18", and N2:N51 is "Fall18". This list is dynamic and will be changing quite often so the formulas that calculate the top 5 need to be dynamic as well. I've not had to go this far in depth with excel in years and as such this is the first time I've dealt with arrays and lengthy functions, so I apologize in advance if I'm missing any pertinent information. I'm also using excel 2016/excel 365.

Thanks,
Zach
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Try these;

in cell C11:
=IF($D11=$D10,INDEX(OFFSET($L$1,MATCH($C10,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D11,OFFSET($M$1,MATCH($C10,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D11,$M$2:$M$51,0)))
Then copy it down through cell C15

in cell D11:
=LARGE($M$2:$M$51,ROWS($A$1:A1))
Then copy it down through cell D15

in cell C35:
=IF($D35=$D34,INDEX(OFFSET($L$1,MATCH($C34,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D35,OFFSET($N$1,MATCH($C34,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D35,$N$2:$N$51,0)))
Then copy it down through cell C39

in cell D35:
=LARGE($N$2:$N$51,ROWS($A$1:A1))
Then copy it down through cell D39
 
Upvote 0
Chrisdontm said:
Try these;

in cell C11:
=IF($D11=$D10,INDEX(OFFSET($L$1,MATCH($C10,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D11,OFFSET($M$1,MATCH($C10,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D11,$M$2:$M$51,0)))
Then copy it down through cell C15

in cell D11:
=LARGE($M$2:$M$51,ROWS($A$1:A1))
Then copy it down through cell D15

in cell C35:
=IF($D35=$D34,INDEX(OFFSET($L$1,MATCH($C34,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D35,OFFSET($N$1,MATCH($C34,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D35,$N$2:$N$51,0)))
Then copy it down through cell C39

in cell D35:
=LARGE($N$2:$N$51,ROWS($A$1:A1))
Then copy it down through cell D39
Click to expand...

Wow, that works perfectly, thank you so much! You all make it seem so easy!
 
Upvote 0
Chrisdontm said:
Try these;

in cell C11:
=IF($D11=$D10,INDEX(OFFSET($L$1,MATCH($C10,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D11,OFFSET($M$1,MATCH($C10,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D11,$M$2:$M$51,0)))
Then copy it down through cell C15

in cell D11:
=LARGE($M$2:$M$51,ROWS($A$1:A1))
Then copy it down through cell D15

in cell C35:
=IF($D35=$D34,INDEX(OFFSET($L$1,MATCH($C34,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D35,OFFSET($N$1,MATCH($C34,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D35,$N$2:$N$51,0)))
Then copy it down through cell C39

in cell D35:
=LARGE($N$2:$N$51,ROWS($A$1:A1))
Then copy it down through cell D39
Click to expand...

I posted too soon. The first 2 formulas seems to working perfectly for the 1st output table, however formula 3 for the second output table is giving me an #N/A error for the 4th rank value. The current calculation for the output are VA-7, PA-3, FL-2, #N/A-2, IN-1. This is all correct except the #N/A error should be reading "NJ"

I originally gave you the wrong output range for this table (C35:D39) the correct range is (C34:D38). I did correct the formula accordingly to reflect that change, but maybe I'm missing something? The corrected formula is:

in cell C34
=IF($D34=$D33,INDEX(OFFSET($L$1,MATCH($C33,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),MATCH($D34,OFFSET($N$1,MATCH($C33,$L$1:$L$50,0),,51-MATCH($C10,$L$1:$L$51,0),1),0)),INDEX($L$2:$L$51,MATCH($D34,$N$2:$N$51,0)))
Copied down to cell C38
 
Upvote 0
I think I did this correctly? I saved a copy of the file as a "Formatted Text (Space Delimited)" .txt file, the original file was an .xlsx file. The notepad is copied below and the delimiter for importing this into excel is "Tab" Hope this is what you were asking for.

201820 State 201820 201840
AC/AK 7 AK 0 0
HE 8 AL 0 0
WD 4 AR 0 0
RJ 0 AZ 0 0
Total Apps. 15 CA 0 0
Av. UG GPA 3.08 CO 0 0
CT 0 0
Top 5 States DE 0 0
State Apps FL 1 2
1 GA 0 0
2 HI 0 0
3 IA 0 0
4 ID 0 0
5 IL 0 0
***Check for repating app IN 0 1
numbers for 5th rank*** KS 0 0
KY 0 0
LA 0 1
MA 0 0
MD 2 1
ME 0 0
MI 1 0
201840 MN 0 0
AC/AK 5 MO 0 0
HE 15 MS 0 0
WD 3 MT 0 0
RJ 0 NC 0 1
Total Apps. 20 ND 0 0
Av. UG GPA 3.08 NE 0 0
NH 0 0
Top 5 States NJ 0 2
State Apps NM 0 0
1 NV 0 0
2 NY 1 0
3 OH 0 0
4 OK 0 0
5 OR 0 0
***Check for repating app PA 2 3
numbers for 5th rank*** RI 0 0
SC 0 1
SD 0 0
TN 0 0
TX 0 1
UT 0 0
VA 8 7
VT 0 0
WA 0 0
WI 0 0
WV 0 0
WY 0 0
 
Upvote 0
That didn't seem to post with the correct spacing. Could you provide input on how to post the file via what is acceptable by the mrexcel forum?
 
Upvote 0
[TABLE="width: 671"]
<tbody>[TR]
[TD="class: xl72, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 175, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]201820
[/TD]
[TD="class: xl72, width: 66, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl74, width: 56, bgcolor: #4F81BD"]State
[/TD]
[TD="class: xl74, width: 66, bgcolor: #4F81BD"]201820
[/TD]
[TD="class: xl74, width: 66, bgcolor: #4F81BD"]201840
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]AC/AK
[/TD]
[TD="class: xl68, bgcolor: #9BBB59"]7
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]AK
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]HE
[/TD]
[TD="class: xl69, bgcolor: #4F81BD"]8
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]AL
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]WD
[/TD]
[TD="class: xl70, bgcolor: #F79646"]4
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]AR
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]RJ
[/TD]
[TD="class: xl71, bgcolor: #C0504D"]0
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]AZ
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]Total Apps.
[/TD]
[TD="class: xl66, bgcolor: transparent"]15
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]CA
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]Av. UG GPA
[/TD]
[TD="class: xl67, bgcolor: transparent"]3.08
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]CO
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]CT
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]Top 5 States
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]DE
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]State
[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]Apps
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]FL
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]1
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]1
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]GA
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]2
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]HI
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]3
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]IA
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]4
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]ID
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]5
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]IL
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]***Check for repating app
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]IN
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]numbers for 5th rank***
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]KS
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]KY
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]LA
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]MA
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]MD
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]ME
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]MI
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]201840
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]MN
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]AC/AK
[/TD]
[TD="class: xl68, bgcolor: #9BBB59"]5
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]MO
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]HE
[/TD]
[TD="class: xl69, bgcolor: #4F81BD"]15
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]MS
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]WD
[/TD]
[TD="class: xl70, bgcolor: #F79646"]3
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]MT
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]RJ
[/TD]
[TD="class: xl71, bgcolor: #C0504D"]0
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]NC
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]Total Apps.
[/TD]
[TD="class: xl66, bgcolor: transparent"]20
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]ND
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]Av. UG GPA
[/TD]
[TD="class: xl67, bgcolor: transparent"]3.08
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]NE
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]NH
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]Top 5 States
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]NJ
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]State
[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]Apps
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]NM
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]1
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]NV
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]2
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]NY
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]3
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]OH
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]4
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]OK
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] "]5
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]OR
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]***Check for repating app
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]PA
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1F497D]#1F497D[/URL] , colspan: 3"]numbers for 5th rank***
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]RI
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]SC
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]SD
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]TN
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]TX
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]UT
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]VA
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]8
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]7
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]VT
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]WA
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]WI
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] "]WV
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]WY
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you, I think I got it now. The range shown here is A1:N51.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question Question
Creating macro for nested calculations within calculations
Replies
2
Views
163
LizN
L
N
  • Question Question
2-step Dynamic Ranges and Charts
Replies
0
Views
1K
Nick Loughton
N
T
  • Question Question
VBA code to export specific variably named tabs to new workbook?
Replies
2
Views
651
thebigejr
T
S
  • Question Question
Trendline values using Dynamic Range in Excel - comparing with LINEST function
Replies
1
Views
1K
Domenic
D
C
  • Question Question
Excel VBA- Viewing and Updating existing worksheet data with Excel UserForm with Dependent Comboboxes
Replies
2
Views
1K
charliechaz
C

Forum statistics

Threads
1,224,919
Messages
6,181,760
Members
453,064
Latest member
robatthe2A

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top