ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
S.NOINDEX
2
1COUNT
3
2DATE
4
3DATEDIF
5
4DSUM
6
5EDATE
7
6FREQUENCY
8
7HLOOKUP
9
8HLOOKUP- DEFINE NAME
10
9HLOOKUP-ARRAY
11
10IF
12
11IF AND IF OR
13
12INDEX-MATCH
14
13LOAN
15
14LOAN-EMI
16
15LOOKUP
17
16LOOKUP-ARRAY
18
17LOOKUP-DEFINE NAME
19
18NESTEDIF
20
19NUMBER WITH TEXT
21
20RANK
22
21RECURRING
23
22RECURRING-100
24
23REPEAT
25
24SUBTOTAL+VLOOKUP
26
25SUMIF
27
26SUMIFS
28
27SUMPRODUCT
29
28VLOOKUP
30
29VLOOKUP- DEFINE NAME
31
30VLOOKUP-ARRAY
32
31
33
32
34
33
35
34
36
35
37
36
38
37
39
38
40
39
41
40
42
41
43
42
44
43
45
44
46
45
47
46
48
47
49
48
50
49
51
50
52
51
53
52
54
53
55
54
56
55
57
56
58
57
59
58
60
59
61
60
62
61
63
62
64
63
65
64
66
65
67
66
68
67
69
68
70
69
71
70
72
71
73
72
74
73
75
74
76
75
77
76
78
77
79
78
80
79
81
80
82
81
83
82
84
83
85
84
86
85
87
86
88
87
89
88
90
89
91
90
92
91
93
92
94
93
95
94
96
95
97
96
98
97
99
98
100
99