Categories
- Excel (1,152)
- 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 (80)
- Advanced filter (6)
- Data validation (28)
- Drop down lists (25)
- Excel table (22)
- 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 (899)
- Array manipulation (40)
- CHOOSECOLS function (1)
- CHOOSEROWS function (1)
- DROP function (6)
- EXPAND function (2)
- HSTACK function (5)
- TAKE function (1)
- TOCOL function (18)
- TOROW function (2)
- VSTACK function (13)
- WRAPCOLS function (1)
- WRAPROWS function (1)
- Compatibility (23)
- 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 (3)
- 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 (87)
- DATE function (29)
- DATEDIF function (4)
- DATEVALUE function (3)
- DAY function (10)
- DAYS function (1)
- EDATE function (2)
- EOMONTH function (2)
- HOUR function (5)
- MINUTE function (2)
- MONTH function (29)
- NETWORKDAYS function (2)
- NETWORKDAYS.INTL function (2)
- NOW function (2)
- SECOND function (2)
- TIME function (7)
- TIMEVALUE function (1)
- TODAY function (9)
- WEEKDAY function (15)
- WEEKNUM function (5)
- WORKDAY function (2)
- YEAR function (27)
- YEARFRAC function (1)
- Engineering (45)
- BIN2DEC function (2)
- BIN2HEX function (1)
- BIN2OCT function (1)
- BITAND function (1)
- BITLSHIFT function (1)
- BITOR function (1)
- BITRSHIFT function (1)
- BITXOR function (2)
- COMPLEX function (1)
- CONVERT function (1)
- DEC2BIN function (2)
- DEC2HEX function (2)
- DEC2OCT function (1)
- DELTA function (1)
- HEX2BIN function (1)
- HEX2DEC function (3)
- HEX2OCT function (1)
- IMABS function (2)
- IMAGINARY function (1)
- IMARGUMENT function (1)
- IMCONJUGATE function (1)
- IMCOS function (1)
- IMCOSH function (1)
- IMCOT function (1)
- IMCSC function (1)
- IMCSCH function (1)
- IMDIV function (1)
- IMEXP function (1)
- IMLN (1)
- IMLOG10 function (1)
- IMLOG2 function (1)
- IMPOWER function (1)
- IMPRODUCT function (1)
- IMREAL function (1)
- IMSEC function (1)
- IMSECH function (1)
- IMSIN function (1)
- IMSINH function (1)
- IMSQRT function (1)
- IMSUB function (1)
- IMSUM function (1)
- IMTAN function (1)
- Financial (29)
- ACCRINT function (1)
- ACCRINTM function (1)
- AMORDEGRC function (1)
- AMORLINC function (1)
- CUMIPMT function (1)
- CUMPRINC function (1)
- DB function (1)
- DDB function (1)
- DOLLARFR function (1)
- EFFECT function (1)
- FV function (1)
- IPMT function (1)
- ISPMT function (1)
- NOMINAL function (1)
- NPER function (1)
- PDURATION function (1)
- PMT function (1)
- PPMT function (1)
- PRICEMAT function (1)
- PV Function (1)
- RATE function (1)
- RRI function (1)
- SYD function (1)
- TBILLEQ function (1)
- TBILLPRICE function (1)
- TBILLYIELD function (1)
- VDB function (1)
- XNPV function (1)
- YIELD function (1)
- Information (93)
- CELL function (2)
- ERROR.TYPE function (1)
- INFO function (1)
- ISBLANK function (9)
- ISERR function (1)
- ISERROR function (26)
- ISFORMULA function (2)
- ISLOGICAL function (1)
- ISNA function (3)
- ISNONTEXT function (1)
- ISNUMBER function (36)
- ISODD function (1)
- ISREF function (1)
- ISTEXT function (9)
- N function (1)
- NA function (3)
- SHEET function (1)
- SHEETS function (1)
- TYPE function (1)
- Logical (352)
- AND function (8)
- BYCOL function (1)
- BYROW function (4)
- FALSE function (29)
- IF function (279)
- IFERROR function (94)
- IFNA function (5)
- IFS function (1)
- ISEVEN funtion (1)
- LAMBDA function (14)
- MAKEARRAY function (1)
- MAP function (2)
- NOT function (19)
- OR function (13)
- REDUCE function (7)
- SCAN function (2)
- SWITCH function (3)
- TRUE function (59)
- XOR function (1)
- Lookup and reference (399)
- ADDRESS function (5)
- AREAS function (1)
- CHOOSE function (6)
- COLUMN function (65)
- COLUMNS function (37)
- FILTER function (70)
- FORMULATEXT function (1)
- HLOOKUP function (1)
- HYPERLINK function (9)
- INDEX function (238)
- INDIRECT function (30)
- LOOKUP function (34)
- MATCH function (217)
- OFFSET function (22)
- ROW function (188)
- ROWS function (99)
- SORT function (22)
- SORTBY function (15)
- STOCKHISTORY function (2)
- TRANSPOSE function (44)
- UNIQUE function (41)
- VLOOKUP function (11)
- XLOOKUP function (3)
- XMATCH function (1)
- Math and trigonometry (296)
- ABS function (14)
- ACOS function (1)
- ACOSH function (1)
- ACOT function (1)
- ACOTH function (1)
- AGGREGATE function (7)
- ASIN function (1)
- ASINH function (1)
- ATAN function (1)
- ATAN2 function (1)
- ATANH function (1)
- BASE function (2)
- CEILING function (1)
- COMBIN function (2)
- 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)
- FIXED function (1)
- FLOOR.MATH function (1)
- FLOOR.PRECISE function (1)
- GCD function (1)
- GDC function (1)
- INT function (11)
- LCM function (1)
- LET function (47)
- LN function (1)
- LOG function (1)
- LOG10 function (2)
- MINVERSE function (2)
- MMULT function (31)
- MOD function (14)
- MROUND function (1)
- MULTINOMIAL function (1)
- MUNIT function (1)
- PI function (2)
- POWER function (4)
- PRODUCT function (2)
- QUOTIENT function (4)
- RADIANS function (2)
- RAND function (3)
- RANDARRAY function (2)
- RANDBETWEEN function (13)
- ROUND function (4)
- ROUNDDOWN function (5)
- ROUNDUP function (5)
- SEC function (1)
- SECH function (1)
- SEQUENCE function (30)
- SERIESSUM function (1)
- SIGN function (3)
- SIN function (1)
- SINH function (1)
- SQRT function (1)
- SUBTOTAL function (14)
- SUM function (60)
- SUMIF function (6)
- SUMIFS function (7)
- SUMPRODUCT function (80)
- SUMSQ function (1)
- SUMX2MY2 function (1)
- SUMX2PY2 function (1)
- SUMXMY2 function (1)
- TAN function (1)
- TANH function (1)
- TRUNC function (1)
- Statistical (412)
- 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 (11)
- COUNTA function (21)
- COUNTBLANK function (2)
- COUNTIF function (160)
- COUNTIFS function (55)
- 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 (20)
- 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 (28)
- LINEST function (1)
- LOGEST function (1)
- LOGNORM.DIST function (1)
- MAX function (34)
- MAXIFS function (6)
- MEDIAN function (3)
- MIN function (59)
- MINA function (1)
- MINIFS function (8)
- 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 (141)
- 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 (156)
- ARRAYTOTEXT Function (1)
- ASC function (1)
- CHAR function (9)
- CLEAN function (1)
- CODE function (5)
- CONCAT function (2)
- CONCATENATE function (2)
- EXACT function (10)
- FIND function (8)
- LEFT function (15)
- LEN function (30)
- LOWER function (1)
- MID function (22)
- REPLACE function (1)
- REPT function (6)
- RIGHT function (9)
- SEARCH function (38)
- SUBSTITUTE function (16)
- T function (1)
- TEXT function (24)
- TEXTAFTER function (2)
- TEXTBEFORE function (1)
- TEXTJOIN function (38)
- TEXTSPLIT function (16)
- TRIM function (12)
- UNICHAR function (1)
- UNICODE function (1)
- UPPER function (5)
- VALUE function (1)
- VALUETOTEXT function (1)
- Web (9)
- ENCODEURL function (1)
- FILTERXML function (6)
- IMAGE function (1)
- WEBSERVICE function (1)
- Array manipulation (40)
- 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