Formula.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Formula.xlsx as PDF for free.
More details
- Words: 980
- Pages: 9
TOTAL, AVG,GRADING, TABLE SL NO 1 2 3 4 5 6 7 8 9 10
REG NO 501 505 506 507 508 509 510 502 503 504
STUDENT NAME A E F G H I J B C D
1 39 39 39 40 41 50 70
2
3
39 39 40 46 51 72 39
39 39 40 45 52 73 39 39 39
39
No of students "A" Grade No of students "B" Grade No of students "C" Grade No of students "F" Grade
MAIL MERGE CONCATENATE STUDENT NAME Year
SL NO
REG NO
left 4 digits
right 4 digits
1
123456789
A
2018
1234
6789
2
123456790
E
2018
1234
6790
3
123456791
F
2018
1234
6791
4
123456792
G
2018
1234
6792
5
123456793
H
2018
1234
6793
6 7 8 9 10
123456794 123456795 123456796 123456797 123456798
I J B C D
1234 1234 1234 1234 1234
6794 6795 6796 6797 6798
SLDFSDBSD JFAJDD LKSDFJLASJ LKSDFJAJS LDFJSLASDJ LSDFJASDL
lower case sldfsdbsd jfajdd lksdfjlasj lksdfjajs ldfjslasdj lsdfjasdl
VLOOKUP SL NO 1 2 3 4 5 6 7 8 9 10
REG NO 123456789 123456790 123456791 123456792 123456793 123456794 123456795 123456796 123456797 123456798
STUDENT NAME A E F G H I J B C D
vlookup A E F G H I J B C D
CASE CHANGING
asdfjlsdjfjs fjlasdjfjsd lljsdflasdjflj sdfjkasdljf sljkfasdkl;jf skl;dfjals;dj
1 123456789 987654321 123456789 987654321 123456789 987654321 123456789
UPPER CASE ASDFJLSDJFJS FJLASDJFJSD LLJSDFLASDJFLJ SDFJKASDLJF SLJKFASDKL;JF SKL;DFJALS;DJ
TRUE AND FALSE 2 1 123456789 1 987654321 1 123456789 1 987654321 1 123456789 1 987654322 123456781
0
0 0
987654321
87654321
0
RANK & CONDITIONAL FORMA S.No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
REGD.NO ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF
REGD.NO 15L31A0325 14L31A03G7 15L31A0328 15L31A0347 15L31A0309 15L31A0314 15L31A0315 15L31A0322 15L31A0331 15L31A0339 15L31A0317 15L31A0350 14L31A03A8 15L31A0320 15L31A0326 15L31A0366 15L31A0363 14L31A03H3 14L31A0355 15L31A0358
sub 1 71 78 57 55 53 48 46 54 24 39 61 47 43 48 50 56 23 36 AB 13 4
sub 2 92 96 60 51 50 56 52 46 61 47 54 44
left
MID
RIGHT
0 ABCD ABCD ABCD ABCD ABCD
15L31A0325 15L31A0325 15L31A0325 15L31A0325 15L31A0325 15L31A0325
ABCDEF ABCDEF ABCDEF ABCDEF ABCDEF ABCDEF
43 58 40 19 31 36 52 46 2
sub 3 63 58 71 64 55 44 35 36 53 52 31 37 51 AB 44 42 29 27 17 17 6
LEFT DETELETED
D.NO.2-158,VISWESW VISWESWARAYAPURAM,MJYAGROUP,MALIKIPURAM MANDAL,VISWESWARAP
4
5
6
39 39 40 45 53 74
39 39 40 46 54 75
39 40 49 69 76
39 39
39 39
TOTAL 39 195 234 240 272 329 440 78 117 156
AVG 7 33 39 40 45 55 73 13 20 26
GRADE F F F C C B A F F F
GRADING 1 1 2 6
7
6
6
Axis Title
5 4 3
2
2
1
1 0
addings 2018 123456789
2018123456789
2018 123456790
2018123456790
2018 123456791
2018123456791
2018 123456792
2018123456792
2018 123456793
2018123456793
1
2
1 3
2018123456794 2018123456795 2018123456796 2018123456797 2018123456798
SL NO 1 2 3 4 5 6 7 8 9 10
SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD
Proper Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd
v look up data REG NO STUDENT NAME 123456789 A 123456790 E 123456791 F 123456792 G 123456793 H 123456794 I 123456795 J 123456796 B 123456797 C 123456798 D
NK & CONDITIONAL FORMATING & COUNTIF sub 4 78 51 87 85 58 58 52 48 49 35 50 43 40 48 39 29 35 55 16 15 3
sub 5 82 87 59 47 24 46 43 34 31 43 AB 49 48 29 18 21 39 27 26 8 10
sub 6 69 79 78 85 52 35 48 49 40 40 58 33 27 59 41 45 31 20 22 14 6
AM MANDAL,VISWESWARAPURAM,EAST GODAVARI-533254
Total 455 449 412 387 292 287 276 267 258 256 254 253 252 242 232 212 208 201 133 113
Avg 76 75 69 65 49 48 46 45 43 43 42 42 42 40 39 35 35 34 22 19
Grade A B B B D D D D D D D D D D D D D F F F
Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
6
2 1
1 3
SL NO
REG NO STUDENT NAME 101 A 102 B 103 C 104 D 105 E 106 F 107 G 108 H 109 I 110 G
1
2 45 89 42 65 62 63 72 25 46 90
3 42 45 60 62 72 81 55 22 65 92
4 56 55 62 89 85 88 45 30 62 85
No of students "A" Grade No of students "B" Grade No of students "C" Grade No of students "F" Grade
SL NO 1 2 3 4 5 6 7 8 9 10
REG NO STUDENT NAMEYear left 4 digits 123451 A 2018 1234 123551 B 2018 1235 123661 C 2018 1236 123771 D 2018 1237 123881 E 2018 1238 123881 F 2018 1238 123111 G 2018 1231 123222 H 2018 1232 123333 I 2018 1233 123555 G 2018 1235
5 64 62 55 78 80 75 50 38 72 80
6 50 54 62 82 70 90 58 35 70 81
4 2 3 1
right 4 digits 3451 3551 3661 3771 3881 3881 3111 3222 3333 3555
addings
75 56 60 85 65 82 55 32 65 85
TOTAL 332 361 341 461 434 479 335 182 380 513
AVG
GRADE 55 C 60 B 57 C 77 A 72 A 80 A 56 C 30 F 63 B 86 A
REG NO 501 505 506 507 508 509 510 502 503 504
STUDENT NAME A E F G H I J B C D
1 39 39 39 40 41 50 70
2
3
39 39 40 46 51 72 39
39 39 40 45 52 73 39 39 39
39
No of students "A" Grade No of students "B" Grade No of students "C" Grade No of students "F" Grade
MAIL MERGE CONCATENATE STUDENT NAME Year
SL NO
REG NO
left 4 digits
right 4 digits
1
123456789
A
2018
1234
6789
2
123456790
E
2018
1234
6790
3
123456791
F
2018
1234
6791
4
123456792
G
2018
1234
6792
5
123456793
H
2018
1234
6793
6 7 8 9 10
123456794 123456795 123456796 123456797 123456798
I J B C D
1234 1234 1234 1234 1234
6794 6795 6796 6797 6798
SLDFSDBSD JFAJDD LKSDFJLASJ LKSDFJAJS LDFJSLASDJ LSDFJASDL
lower case sldfsdbsd jfajdd lksdfjlasj lksdfjajs ldfjslasdj lsdfjasdl
VLOOKUP SL NO 1 2 3 4 5 6 7 8 9 10
REG NO 123456789 123456790 123456791 123456792 123456793 123456794 123456795 123456796 123456797 123456798
STUDENT NAME A E F G H I J B C D
vlookup A E F G H I J B C D
CASE CHANGING
asdfjlsdjfjs fjlasdjfjsd lljsdflasdjflj sdfjkasdljf sljkfasdkl;jf skl;dfjals;dj
1 123456789 987654321 123456789 987654321 123456789 987654321 123456789
UPPER CASE ASDFJLSDJFJS FJLASDJFJSD LLJSDFLASDJFLJ SDFJKASDLJF SLJKFASDKL;JF SKL;DFJALS;DJ
TRUE AND FALSE 2 1 123456789 1 987654321 1 123456789 1 987654321 1 123456789 1 987654322 123456781
0
0 0
987654321
87654321
0
RANK & CONDITIONAL FORMA S.No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
REGD.NO ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF
REGD.NO 15L31A0325 14L31A03G7 15L31A0328 15L31A0347 15L31A0309 15L31A0314 15L31A0315 15L31A0322 15L31A0331 15L31A0339 15L31A0317 15L31A0350 14L31A03A8 15L31A0320 15L31A0326 15L31A0366 15L31A0363 14L31A03H3 14L31A0355 15L31A0358
sub 1 71 78 57 55 53 48 46 54 24 39 61 47 43 48 50 56 23 36 AB 13 4
sub 2 92 96 60 51 50 56 52 46 61 47 54 44
left
MID
RIGHT
0 ABCD ABCD ABCD ABCD ABCD
15L31A0325 15L31A0325 15L31A0325 15L31A0325 15L31A0325 15L31A0325
ABCDEF ABCDEF ABCDEF ABCDEF ABCDEF ABCDEF
43 58 40 19 31 36 52 46 2
sub 3 63 58 71 64 55 44 35 36 53 52 31 37 51 AB 44 42 29 27 17 17 6
LEFT DETELETED
D.NO.2-158,VISWESW VISWESWARAYAPURAM,MJYAGROUP,MALIKIPURAM MANDAL,VISWESWARAP
4
5
6
39 39 40 45 53 74
39 39 40 46 54 75
39 40 49 69 76
39 39
39 39
TOTAL 39 195 234 240 272 329 440 78 117 156
AVG 7 33 39 40 45 55 73 13 20 26
GRADE F F F C C B A F F F
GRADING 1 1 2 6
7
6
6
Axis Title
5 4 3
2
2
1
1 0
addings 2018 123456789
2018123456789
2018 123456790
2018123456790
2018 123456791
2018123456791
2018 123456792
2018123456792
2018 123456793
2018123456793
1
2
1 3
2018123456794 2018123456795 2018123456796 2018123456797 2018123456798
SL NO 1 2 3 4 5 6 7 8 9 10
SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD
Proper Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd
v look up data REG NO STUDENT NAME 123456789 A 123456790 E 123456791 F 123456792 G 123456793 H 123456794 I 123456795 J 123456796 B 123456797 C 123456798 D
NK & CONDITIONAL FORMATING & COUNTIF sub 4 78 51 87 85 58 58 52 48 49 35 50 43 40 48 39 29 35 55 16 15 3
sub 5 82 87 59 47 24 46 43 34 31 43 AB 49 48 29 18 21 39 27 26 8 10
sub 6 69 79 78 85 52 35 48 49 40 40 58 33 27 59 41 45 31 20 22 14 6
AM MANDAL,VISWESWARAPURAM,EAST GODAVARI-533254
Total 455 449 412 387 292 287 276 267 258 256 254 253 252 242 232 212 208 201 133 113
Avg 76 75 69 65 49 48 46 45 43 43 42 42 42 40 39 35 35 34 22 19
Grade A B B B D D D D D D D D D D D D D F F F
Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
6
2 1
1 3
SL NO
REG NO STUDENT NAME 101 A 102 B 103 C 104 D 105 E 106 F 107 G 108 H 109 I 110 G
1
2 45 89 42 65 62 63 72 25 46 90
3 42 45 60 62 72 81 55 22 65 92
4 56 55 62 89 85 88 45 30 62 85
No of students "A" Grade No of students "B" Grade No of students "C" Grade No of students "F" Grade
SL NO 1 2 3 4 5 6 7 8 9 10
REG NO STUDENT NAMEYear left 4 digits 123451 A 2018 1234 123551 B 2018 1235 123661 C 2018 1236 123771 D 2018 1237 123881 E 2018 1238 123881 F 2018 1238 123111 G 2018 1231 123222 H 2018 1232 123333 I 2018 1233 123555 G 2018 1235
5 64 62 55 78 80 75 50 38 72 80
6 50 54 62 82 70 90 58 35 70 81
4 2 3 1
right 4 digits 3451 3551 3661 3771 3881 3881 3111 3222 3333 3555
addings
75 56 60 85 65 82 55 32 65 85
TOTAL 332 361 341 461 434 479 335 182 380 513
AVG
GRADE 55 C 60 B 57 C 77 A 72 A 80 A 56 C 30 F 63 B 86 A
More Documents from "Madina Vali"
Formula.xlsx
June 2020 14
349554736-hasil-audit-klinis-kia-docx.docx
May 2020 18
6. . . Ep. Sop Indikator Penilaian Kinerja
October 2019 21
Sarcoidoza.sdr.mediastinal
April 2020 8
Tromboflebite.embolia Pulmonara
April 2020 8