Categories
- Excel (1,162)
- Add-in (4)
- Basic formulas (88)
- Count (11)
- Dates (15)
- Extract (10)
- INDEX + MATCH (7)
- Logic (9)
- Lookups (8)
- Small (8)
- Sum (15)
- Text string manipultion (3)
- Time (3)
- Blank cells (5)
- Calendar (16)
- Case sensitive (3)
- Charts (92)
- 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 (7)
- 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)
- STACKED COLUMN chart (1)
- stock chart (4)
- Sunburst chart (1)
- Surface chart (1)
- Treemap chart (1)
- Waterfall chart (1)
- Combinations (2)
- Combine Merge (9)
- Compare (16)
- Concatenate (5)
- Conditional formatting (54)
- CF-basic-formulas (4)
- CF-built-in (3)
- CF-compare (6)
- CF-dates (9)
- CF-duplicates (9)
- CF-min-max (3)
- CF-misc (6)
- CF-search (4)
- CF-unique-distinct (4)
- Highlight Cells Rules (4)
- Highlight duplicates (1)
- Top/Bottom Rules (3)
- Count unique distinct records (1)
- Count values (32)
- COUNTIF (1)
- Dates (46)
- Overlapping (17)
- Duplicate records (1)
- Duplicate values (16)
- Excel Basics (16)
- Features (79)
- Advanced filter (6)
- Data validation (28)
- Drop down lists (25)
- Excel table (21)
- Named range (5)
- Pivot table (16)
- Solver (7)
- Filter emails (2)
- Filter records (9)
- Finance (15)
- Stock market trend (5)
- Stock portfolio (5)
- Find numbers in sum (5)
- Formula characters (1)
- Frequency table (5)
- Functions (916)
- Array manipulation (55)
- CHOOSECOLS function (2)
- CHOOSEROWS function (2)
- DROP function (8)
- EXPAND function (3)
- HSTACK function (11)
- TAKE function (2)
- TOCOL function (24)
- TOROW function (3)
- VSTACK function (20)
- WRAPCOLS function (2)
- WRAPROWS function (2)
- Compatibility (25)
- BETADIST function (2)
- BETAINV function (2)
- BINOMDIST function (2)
- CHIDIST function (2)
- CHIINV function (2)
- CHITEST function (2)
- CONFIDENCE (1)
- COVAR function (2)
- CRITBINOM function (2)
- EXPONDIST function (2)
- FDIST function (2)
- FLOOR function (2)
- FORECAST function (2)
- FTEST function (2)
- GAMMADIST function (2)
- LOGNORMDIST function (2)
- MODE function (2)
- PERCENTRANK function (2)
- QUARTILE function (2)
- RANK function (5)
- STDEV function (2)
- Database (12)
- DAVERAGE function (2)
- DCOUNT function (2)
- DGET function (2)
- DMAX function (2)
- DMIN function (2)
- DOUNTA function (1)
- DPRODUCT function (1)
- DSTDEV function (2)
- DSTDEVP function (2)
- DSUM function (2)
- DVARP function (2)
- Date and Time (95)
- DATE function (35)
- DATEDIF function (5)
- DATEVALUE function (4)
- DAY function (14)
- DAYS function (2)
- EDATE function (4)
- EOMONTH function (4)
- HOUR function (7)
- MINUTE function (4)
- MONTH function (38)
- NETWORKDAYS function (3)
- NETWORKDAYS.INTL function (3)
- NOW function (3)
- SECOND function (3)
- TIME function (8)
- TIMEVALUE function (2)
- TODAY function (11)
- WEEKDAY function (18)
- WEEKNUM function (7)
- WORKDAY function (3)
- YEAR function (31)
- YEARFRAC function (2)
- Engineering (48)
- BIN2DEC function (3)
- BIN2HEX function (2)
- BIN2OCT function (2)
- BITAND function (2)
- BITLSHIFT function (2)
- BITOR function (2)
- BITRSHIFT function (2)
- BITXOR function (3)
- COMPLEX function (3)
- CONVERT function (2)
- DEC2BIN function (4)
- DEC2HEX function (3)
- DEC2OCT function (2)
- DELTA function (2)
- HEX2BIN function (2)
- HEX2DEC function (4)
- HEX2OCT function (2)
- IMABS function (4)
- IMAGINARY function (3)
- IMARGUMENT function (2)
- IMCONJUGATE function (2)
- IMCOS function (2)
- IMCOSH function (2)
- IMCOT function (2)
- IMCSC function (2)
- IMCSCH function (2)
- IMDIV function (2)
- IMEXP function (2)
- IMLN (1)
- IMLOG10 function (2)
- IMLOG2 function (2)
- IMPOWER function (2)
- IMPRODUCT function (3)
- IMREAL function (3)
- IMSEC function (2)
- IMSECH function (2)
- IMSIN function (2)
- IMSINH function (2)
- IMSQRT function (2)
- IMSUB function (2)
- IMSUM function (2)
- IMTAN function (2)
- Financial (31)
- ACCRINT function (2)
- ACCRINTM function (2)
- AMORDEGRC function (1)
- AMORLINC function (2)
- CUMIPMT function (2)
- CUMPRINC function (2)
- DB function (2)
- DDB function (2)
- DOLLARFR function (2)
- EFFECT function (2)
- FV function (2)
- IPMT function (2)
- ISPMT function (2)
- NOMINAL function (1)
- NPER function (2)
- PDURATION function (2)
- PMT function (2)
- PPMT function (2)
- PRICEMAT function (2)
- PV Function (1)
- RATE function (2)
- RRI function (2)
- SYD function (1)
- TBILLEQ function (1)
- TBILLPRICE function (1)
- TBILLYIELD function (1)
- VDB function (1)
- XNPV function (1)
- YIELD function (1)
- Information (103)
- CELL function (2)
- ERROR.TYPE function (1)
- INFO function (1)
- ISBLANK function (9)
- ISERR function (1)
- ISERROR function (31)
- ISFORMULA function (2)
- ISLOGICAL function (1)
- ISNA function (3)
- ISNONTEXT function (1)
- ISNUMBER function (41)
- ISODD function (1)
- ISREF function (1)
- ISTEXT function (10)
- N function (1)
- NA function (5)
- SHEET function (1)
- SHEETS function (1)
- TYPE function (1)
- Logical (372)
- AND function (10)
- BYCOL function (1)
- BYROW function (6)
- FALSE function (35)
- IF function (301)
- IFERROR function (107)
- IFNA function (7)
- IFS function (1)
- ISEVEN funtion (1)
- LAMBDA function (18)
- MAKEARRAY function (1)
- MAP function (2)
- NOT function (20)
- OR function (17)
- REDUCE function (8)
- SCAN function (2)
- SWITCH function (4)
- TRUE function (72)
- XOR function (1)
- Lookup and reference (419)
- ADDRESS function (5)
- AREAS function (1)
- CHOOSE function (7)
- COLUMN function (76)
- COLUMNS function (41)
- FILTER function (101)
- FORMULATEXT function (1)
- HLOOKUP function (1)
- HYPERLINK function (9)
- INDEX function (255)
- INDIRECT function (35)
- LOOKUP function (36)
- MATCH function (231)
- OFFSET function (25)
- ROW function (202)
- ROWS function (122)
- SORT function (29)
- SORTBY function (19)
- STOCKHISTORY function (2)
- TRANSPOSE function (54)
- UNIQUE function (54)
- VLOOKUP function (11)
- XLOOKUP function (3)
- XMATCH function (1)
- Math and trigonometry (326)
- ABS function (19)
- ACOS function (1)
- ACOSH function (1)
- ACOT function (1)
- ACOTH function (1)
- AGGREGATE function (7)
- ASIN function (1)
- ASINH function (1)
- ATAN function (2)
- ATAN2 function (1)
- ATANH function (1)
- BASE function (3)
- CEILING function (1)
- COMBIN function (2)
- COMBINA function (1)
- COS function (3)
- COSH function (1)
- COT function (1)
- COTH function (1)
- CSC function (1)
- DECIMAL function (1)
- DEGREES function (3)
- EVEN function (2)
- EXP function (1)
- FACT function (7)
- FACTDOUBLE function (1)
- FIXED function (1)
- FLOOR.MATH function (1)
- FLOOR.PRECISE function (1)
- GCD function (1)
- GDC function (1)
- INT function (14)
- LCM function (1)
- LET function (70)
- LN function (1)
- LOG function (2)
- LOG10 function (2)
- MINVERSE function (2)
- MMULT function (35)
- MOD function (17)
- MROUND function (1)
- MULTINOMIAL function (1)
- MUNIT function (1)
- PI function (3)
- POWER function (4)
- PRODUCT function (2)
- QUOTIENT function (5)
- RADIANS function (3)
- RAND function (3)
- RANDARRAY function (5)
- RANDBETWEEN function (13)
- ROUND function (5)
- ROUNDDOWN function (5)
- ROUNDUP function (8)
- SEC function (1)
- SECH function (1)
- SEQUENCE function (44)
- SERIESSUM function (1)
- SIGN function (3)
- SIN function (3)
- SINH function (1)
- SQRT function (1)
- SUBTOTAL function (15)
- SUM function (68)
- SUMIF function (6)
- SUMIFS function (7)
- SUMPRODUCT function (88)
- SUMSQ function (1)
- SUMX2MY2 function (1)
- SUMX2PY2 function (1)
- SUMXMY2 function (1)
- TAN function (1)
- TANH function (1)
- TRUNC function (1)
- Statistical (425)
- AVEDEV function (1)
- AVERAGE function (10)
- AVERAGEA function (1)
- AVERAGEIF function (3)
- 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 (13)
- COUNTA function (23)
- COUNTBLANK function (2)
- COUNTIF function (177)
- COUNTIFS function (58)
- 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 (22)
- GAMMA function (1)
- GAMMA.DIST function (1)
- GEOMEAN function (1)
- GROWTH function (1)
- HARMEAN function (1)
- HYPGEOM.DIST function (1)
- INTERCEPT function (2)
- KURT function (1)
- LARGE function (31)
- LINEST function (1)
- LOGEST function (1)
- LOGNORM.DIST function (1)
- MAX function (37)
- MAXIFS function (7)
- MEDIAN function (3)
- MIN function (64)
- MINA function (1)
- MINIFS function (9)
- MODE.MULT function (1)
- MODE.SNGL function (2)
- NORM.DIST function (2)
- 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 (2)
- SMALL function (158)
- 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 (170)
- ARRAYTOTEXT Function (1)
- ASC function (1)
- CHAR function (10)
- CLEAN function (1)
- CODE function (7)
- CONCAT function (3)
- CONCATENATE function (2)
- EXACT function (10)
- FIND function (9)
- LEFT function (20)
- LEN function (35)
- LOWER function (1)
- MID function (27)
- REPLACE function (1)
- REPT function (8)
- RIGHT function (11)
- SEARCH function (43)
- SUBSTITUTE function (19)
- T function (1)
- TEXT function (27)
- TEXTAFTER function (3)
- TEXTBEFORE function (1)
- TEXTJOIN function (45)
- TEXTSPLIT function (20)
- TRIM function (13)
- UNICHAR function (1)
- UNICODE function (1)
- UPPER function (6)
- VALUE function (1)
- VALUETOTEXT function (1)
- Web (9)
- ENCODEURL function (1)
- FILTERXML function (6)
- IMAGE function (1)
- WEBSERVICE function (1)
- Array manipulation (55)
- Fuzzy lookup (2)
- Hyperlinks (9)
- IF (3)
- Invoice (7)
- Maps (3)
- Mathematics (2)
- Complex numbers (1)
- Maze (3)
- Misc (7)
- Missing values (8)
- Normalize data (2)
- Pathfinding (3)
- PDF (1)
- Permutations (9)
- Random (10)
- Team generator (3)
- Rank (3)
- Rearrange values (5)
- Records (9)
- Relational tables (7)
- Schedule (12)
- Search and return multiple values (13)
- Wildcard Search (1)
- Sequence (7)
- Sort values (23)
- Split values (7)
- Substitute Replace (1)
- SUMPRODUCT (5)
- Templates (16)
- Text string manipulation (3)
- Tournament (2)
- Two-dimensional lookup (6)
- Unique distinct records (8)
- Unique distinct values (31)
- Unique values (11)
- Range (1)
- VBA (157)
- Arrays (3)
- Check-boxes (6)
- Combobox (5)
- Dialog boxes (1)
- Files and folders (14)
- 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 (78)
- Methods (3)
- Evaluate method (1)
- Range.Find method (1)
- TextToColumns method (1)
- Print (5)
- Properties (1)
- Recursive (1)
- Regular expressions (4)
- Statements (19)
- DO LOOP statement (1)
- FOR NEXT statement (6)
- GoTo statement (1)
- IF THEN ELSE statement (6)
- SELECT CASE statement (1)
- SET statement (1)
- WITH … END WITH Statement (4)
- Text boxes (1)
- User Defined Function (29)
- Worksheet (2)
- VLOOKUP (4)
- VLOOKUP and return multiple values (14)
- XLOOKUP (1)
Comments Off on Categories
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form