Common Excel Formulas
2024-10-22 16:19:20 0 Report
Login to view full content
Other creations by the author
Outline/Content
Data Cleaning Class
Trim
ltrim
Rtrim
concatenate
Left
Right
Mid
Replace
Substitute
Find
Search
Len
Lenb
Association Matching Class
VLOOKUP
HLOOKUP
Rank
Index
Match
Row
Column
Offset
Logical Operations
if
and
or
Calculation and Statistical Category
MIN
MAX
Average/Averageifs
Count/Countif/Countifs
SUM/SUMIF/SUMIFS
SUMPRODUCT
QUARTILE
Standard Deviation
Subtotal
Time series category
Today
Now
year/month/day
weekday
WEEKNUM
DATEDIF
Collect
Collect
Collect
Collect
0 Comments
Next page