Categories

Please click here if you are not redirected within a few seconds.

Function Reference

Conditional Formatting

VBA Knowledge Base

User Defined Functions

Advanced Excel Course

Most used functions

COUNTIF function

SUMIFS function

SUMPRODUCT function

VLOOKUP function

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=45edad9c62&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803742&cs=45edad9c62&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

Categories

Categories

Combobox (5)
Excel (1,114)
- Add-in (2)
- Basic formulas (67)
  - Count (10)
  - Dates (14)
  - Extract (7)
  - INDEX + MATCH (6)
  - Logic (9)
  - Lookups (6)
  - Sum (9)
  - Text string manipultion (3)
  - Time (3)
- Blank cells (5)
- Calendar (19)
- Case sensitive (4)
- Charts (95)
  - 100% stacked column chart (1)
  - Animate (3)
  - Area chart (1)
  - Bar chart (2)
  - Box and whisker chart (1)
  - Bubble chart (1)
  - Candlestick chart (1)
  - Chart basics (6)
  - Chart elements (16)
  - Column chart (6)
  - Combination chart (3)
  - Custom charts (6)
  - Data labels (1)
  - Doughnut chart (1)
  - Funnel chart (1)
  - Gantt (2)
  - Highlight (5)
  - Histogram chart (1)
  - Interactive (10)
  - Line chart (4)
  - Map chart (1)
  - Pareto chart (1)
  - Pie chart (1)
  - Radar chart (1)
  - SCATTER (x y) chart (8)
  - Sparkline (3)
    - Column (1)
    - Line (1)
    - Win/loss (1)
  - STACKED COLUMN chart (1)
  - stock chart (6)
  - Sunburst chart (1)
  - Surface chart (1)
  - Treemap chart (1)
  - Waterfall chart (1)
- Combinations (2)
- Combine/Merge (9)
- Compare (17)
- Concatenate (5)
- Conditional formatting (52)
  - CF-basic-formulas (4)
  - CF-built-in (3)
  - CF-compare (6)
  - CF-dates (9)
  - CF-duplicates (9)
  - CF-formatting (3)
  - CF-min-max (3)
  - CF-misc (3)
  - CF-search (4)
  - CF-unique-distinct (3)
  - Highlight Cells Rules (4)
  - Highlight duplicates (1)
  - Top/Bottom Rules (3)
- Count unique distinct records (1)
- Count values (39)
  - Count text values (1)
  - Count unique distinct values (6)
- Dates (58)
  - Overlapping (18)
- Duplicate records (2)
- Duplicate values (19)
- Excel Basics (15)
- Features (72)
  - Advanced filter (6)
  - Data validation (28)
    - Drop down lists (25)
      - Dependent drop down lists (6)
  - Excel table (17)
  - Named range (4)
  - Pivot table (15)
  - Solver (5)
- Filter emails (2)
- Filter records (9)
- Finance (19)
  - Stock market trend (6)
  - Stock portfolio (7)
- Find numbers in sum (4)
- Functions (479)
  - Compatibility (22)
    - BETADIST function (1)
    - BETAINV function (1)
    - BINOMDIST function (1)
    - CHIDIST function (1)
    - CHIINV function (1)
    - CHITEST function (1)
    - CONFIDENCE (1)
    - COVAR function (1)
    - CRITBINOM function (1)
    - EXPONDIST function (1)
    - FDIST function (1)
    - FLOOR function (1)
    - FORECAST function (1)
    - FTEST function (1)
    - GAMMADIST function (1)
    - LOGNORMDIST function (1)
    - MODE function (1)
    - PERCENTRANK function (1)
    - QUARTILE function (1)
    - RANK function (2)
    - STDEV function (1)
  - Database (11)
    - DAVERAGE function (1)
    - DCOUNT function (1)
    - DGET function (1)
    - DMAX function (1)
    - DMIN function (1)
    - DOUNTA function (1)
    - DPRODUCT function (1)
    - DSTDEV function (1)
    - DSTDEVP function (1)
    - DSUM function (1)
    - DVARP function (1)
  - Date and Time (48)
    - DATE function (5)
    - DATEDIF function (2)
    - DATEVALUE function (2)
    - DAY function (2)
    - DAYS function (1)
    - EDATE function (1)
    - EOMONTH function (1)
    - HOUR function (4)
    - MINUTE function (2)
    - MONTH function (6)
    - NETWORKDAYS function (1)
    - NETWORKDAYS.INTL function (1)
    - NOW function (2)
    - SECOND function (2)
    - TIME function (7)
    - TIMEVALUE function (2)
    - TODAY function (7)
    - WEEKDAY function (6)
    - WEEKNUM function (1)
    - WORKDAY function (1)
    - YEAR function (2)
    - YEARFRAC function (1)
  - Engineering (14)
    - BIN2DEC function (1)
    - BIN2HEX function (1)
    - BIN2OCT function (1)
    - BITAND function (1)
    - BITLSHIFT function (1)
    - BITOR function (1)
    - BITRSHIFT function (1)
    - BITXOR function (1)
    - COMPLEX function (1)
    - CONVERT function (1)
    - DEC2BIN function (1)
    - DEC2HEX function (1)
    - DEC2OCT function (1)
    - DELTA function (1)
  - Financial (16)
    - ACCRINT function (1)
    - ACCRINTM function (1)
    - CUMIPMT function (1)
    - CUMPRINC function (1)
    - DB function (1)
    - DOLLARFR function (1)
    - EFFECT function (1)
    - FV function (1)
    - IPMT function (1)
    - ISPMT function (1)
    - NOMINAL function (1)
    - PDURATION function (1)
    - PMT function (1)
    - PPMT function (1)
    - PRICEMAT function (1)
    - RATE function (1)
  - Information (38)
    - CELL function (1)
    - ERROR.TYPE function (1)
    - INFO function (1)
    - ISBLANK function (6)
    - ISERR function (2)
    - ISERROR function (5)
    - ISFORMULA function (1)
    - ISLOGICAL function (1)
    - ISNA function (3)
    - ISNONTEXT function (1)
    - ISNUMBER function (5)
    - ISODD function (1)
    - ISREF function (1)
    - ISTEXT function (5)
    - N function (1)
    - NA function (1)
    - SHEET function (1)
    - SHEETS function (1)
    - TYPE function (1)
  - Logical (29)
    - AND function (4)
    - FALSE function (1)
    - IF function (9)
    - IFERROR function (1)
    - IFNA function (1)
    - IFS function (1)
    - ISEVEN funtion (1)
    - NOT function (7)
    - OR function (6)
    - SWITCH function (1)
    - TRUE function (1)
    - XOR function (1)
  - Lookup and reference (52)
    - ADDRESS function (4)
    - AREAS function (1)
    - CHOOSE function (2)
    - COLUMN function (3)
    - COLUMNS function (5)
    - FORMULATEXT function (1)
    - HLOOKUP function (1)
    - HYPERLINK function (5)
    - INDEX function (3)
    - INDIRECT function (7)
    - LOOKUP function (7)
      - Lookup numerical ranges (1)
    - MATCH function (4)
    - OFFSET function (2)
    - ROW function (7)
    - ROWS function (2)
    - TRANSPOSE function (5)
    - VLOOKUP function (6)
  - Math and trigonometry (120)
    - ABS function (4)
    - ACOS function (1)
    - ACOSH function (1)
    - ACOT function (1)
    - ACOTH function (1)
    - AGGREGATE function (4)
    - ASIN function (1)
    - ASINH function (1)
    - ATAN function (1)
    - ATAN2 function (1)
    - ATANH function (1)
    - BASE function (1)
    - CEILING function (1)
    - COMBIN function (1)
    - COMBINA function (1)
    - COS function (1)
    - COSH function (1)
    - COT function (1)
    - COTH function (1)
    - CSC function (1)
    - DECIMAL function (1)
    - DEGREES function (2)
    - EVEN function (2)
    - EXP function (1)
    - FACT function (7)
    - FACTDOUBLE function (1)
    - FLOOR.MATH function (1)
    - FLOOR.PRECISE function (1)
    - GCD function (1)
    - GDC function (1)
    - INT function (6)
    - LCM function (1)
    - LN function (1)
    - LOG function (1)
    - LOG10 function (1)
    - MINVERSE function (1)
    - MMULT function (10)
    - MOD function (7)
    - MROUND function (1)
    - MULTINOMIAL function (1)
    - MUNIT function (1)
    - PI function (2)
    - POWER function (5)
    - PRODUCT function (1)
    - QUOTIENT function (2)
    - RADIANS function (2)
    - RAND function (2)
    - RANDBETWEEN function (3)
    - SEC function (1)
    - SECH function (1)
    - SERIESSUM function (1)
    - SIGN function (1)
    - SIN function (1)
    - SINH function (1)
    - SQRT function (1)
    - SUBTOTAL function (3)
    - SUM function (16)
    - SUMIF function (2)
    - SUMIFS function (2)
    - SUMPRODUCT function (6)
    - SUMSQ function (1)
    - SUMX2MY2 function (1)
    - SUMX2PY2 function (1)
    - SUMXMY2 function (1)
    - TAN function (1)
    - TANH function (1)
    - TRUNC function (1)
  - Statistical (130)
    - AVEDEV function (1)
    - AVERAGE function (7)
    - AVERAGEA function (1)
    - AVERAGEIF function (2)
    - AVERAGEIFS function (1)
    - BETA.DIST function (1)
    - BETA.INV function (1)
    - BINOM.DIST function (1)
    - BINOM.INV function (1)
    - CHISQ.DIST function (1)
    - CHISQ.DIST.RT function (1)
    - CHISQ.INV function (1)
    - CHISQ.INV.RT function (1)
    - CHISQ.TEST function (1)
    - CONFIDENCE.NORM (1)
    - CONFIDENCE.T function (1)
    - CORREL function (1)
    - COUNT function (4)
    - COUNTA function (10)
    - COUNTBLANK function (2)
    - COUNTIF function (9)
    - COUNTIFS function (6)
    - COVARIANCE.P function (1)
    - COVARIANCE.S function (1)
    - EXPON.DIST function (1)
    - F.DIST function (1)
    - F.DIST.RT (1)
    - F.TEST function (1)
    - FORECAST.LINEAR function (1)
    - FREQUENCY function (8)
    - GAMMA function (1)
    - GAMMA.DIST function (1)
    - GEOMEAN function (1)
    - GROWTH function (1)
    - INTERCEPT function (1)
    - LARGE function (2)
    - LINEST function (1)
    - LOGEST function (1)
    - LOGNORM.DIST function (1)
    - MAX function (4)
    - MAXIFS function (2)
    - MEDIAN function (3)
    - MIN function (5)
    - MINA function (1)
    - MINIFS function (4)
    - MODE.MULT function (1)
    - MODE.SNGL function (1)
    - NORM.DIST function (1)
    - NORM.INV function (1)
    - PERCENTRANK.EXC function (1)
    - PERCENTRANK.INC function (1)
    - PERMUT function (8)
    - PERMUTATIONA function (3)
    - PHI function (1)
    - PROB function (1)
    - QUARTILE.EXC function (1)
    - QUARTILE.INC function (1)
    - RANK.AVG function (1)
    - RANK.EQ function (1)
    - SKEW function (1)
    - SLOPE function (1)
    - SMALL function (7)
    - STANDARDIZE function (1)
    - STDEV.P (1)
    - STDEV.S function (1)
    - STDEVA function (1)
    - STDEVPA function (1)
    - TREND function (1)
    - TRIMMEAN function (1)
    - VAR.P function (1)
    - VAR.S function (1)
  - Text (57)
    - ASC function (1)
    - CHAR function (3)
    - CLEAN function (1)
    - CODE function (3)
    - CONCAT function (1)
    - CONCATENATE function (1)
    - EXACT function (5)
    - FIND function (5)
    - FIXED function (1)
    - LEFT function (4)
    - LEN function (5)
    - LOWER function (1)
    - MID function (5)
    - REPT function (3)
    - RIGHT function (2)
    - SEARCH function (4)
    - SUBSTITUTE function (7)
    - T function (1)
    - TEXT function (7)
    - TEXTJOIN function (4)
    - TRIM function (4)
    - UNICHAR function (1)
    - UNICODE function (1)
    - UPPER function (3)
    - VALUE function (1)
  - Web (2)
    - ENCODEURL function (1)
    - WEBSERVICE function (1)
- Fuzzy lookup (2)
- Hyperlinks (9)
- Invoice (7)
- Maps (3)
- Maze (3)
- Misc (10)
- Missing values (9)
- Normalize data (2)
- Pathfinding (4)
- PDF (1)
- Permutations (9)
- Random (11)
  - Team generator (3)
- Rank (3)
- Rearrange values (5)
- Records (10)
- Related tables (6)
- Schedule (14)
- Search and return multiple values (12)
  - Wildcard Search (1)
- Sequence (8)
- Sort values (26)
- Split values (8)
- Substitute Replace (1)
- Templates (18)
- Text string manipulation (2)
- Tournament (1)
- Two-dimensional lookup (7)
- Unique distinct records (8)
- Unique distinct values (33)
- Unique values (12)
  - Range (2)
- VBA (150)
  - Arrays (3)
  - Check-boxes (6)
  - Combo boxes (2)
  - Dialog boxes (1)
  - Files and folders (16)
  - Form Controls (6)
    - Scroll bar (1)
  - Functions (7)
    - ARRAY function (1)
    - Fix Function (1)
    - INT function (1)
    - JOIN function (1)
    - Lbound Ubound function (1)
    - SGN function (1)
    - SPLIT function (1)
  - Listbox (3)
  - Macro (71)
  - Methods (2)
    - Evaluate method (1)
    - Range.Find method (1)
  - Print (5)
  - Properties (1)
    - RANGE.OFFSET property (1)
  - Recursive (1)
  - Regular expressions (4)
  - Statements (18)
    - DO LOOP statement (1)
    - FOR NEXT statement (6)
    - GoTo statement (1)
    - IF THEN ELSE statement (6)
    - SELECT CASE statement (1)
    - WITH … END WITH Statement (4)
  - Text boxes (1)
  - User Defined Function (31)
  - Worksheet (2)
- VLOOKUP and return multiple values (14)

Comments Off on Categories

Formula categories

Index and Match

String manipulation

Welcome! I am Oscar and here to help you out.
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Free Blog Emails

Get a free PDF book!

Email
Search website