Formulas & functions
How a function works, with worked examples you can paste.
- Excel Median IF: Multiple Criteria Made EasyTo calculate a median in Excel based on multiple criteria, use an array formula with the MEDIAN and IF functions: =MEDIAN(IF((range1=criteria1)*(range2=criteria2), median_range)),…
- Excel Me Average Ka Formula? AVERAGE, AVERAGEIF & MoreExcel me average nikalne ka sabse simple formula hai =AVERAGE(range). Jaise agar aapke numbers A1 se A10 me hain, to =AVERAGE(A1:A10) type…
- Excel Me Divide Ka Formula? (Aur Kaise Use Karein)Excel me divide karne ka formula hai =A1/B1 (forward slash). Jaise aap calculator me ‘/’ use karte hain, waise hi Excel me…
- Excel Max Value Based on Criteria: Formula GuideTo find the maximum value in Excel based on one or more criteria, use MAXIFS (for Excel 2019 and Microsoft 365) or…
- Excel MAX with Criteria: Formula & ExamplesThe quickest way to find the maximum value in Excel based on one or more criteria is to use the MAXIFS function:…
- Excel MAX with NA: Formula to Ignore ErrorsThe direct answer: to find the maximum value in a range while ignoring #N/A errors, use the array formula =MAX(IF(ISNA(range),"",range)) entered with…
- Excel Max IF Multiple Criteria: Formula & ExamplesThe fastest way to find a maximum value in Excel that meets multiple criteria is to use the MAXIFS function, which is…
- Excel Max Date in Range: Formula & ExamplesThe quickest way to find the maximum date in an Excel range is with the MAX function: =MAX(A2:A100) returns the latest date…
- Excel MAX IF: Max with Criteria ExplainedThe direct answer: use the array formula =MAX(IF(range=criteria, max_range)) entered with Ctrl+Shift+Enter in older Excel, or the dynamic-array version =MAX(IF(range=criteria, max_range)) entered…
- Excel Markup Formula from Cost: Easy StepsThe simplest Excel markup formula from cost is =Selling Price / Cost - 1, or equivalently =(Selling Price - Cost) / Cost.…
- Excel MATCH Lookup Array: How to Use ItThe MATCH function in Excel finds the position of a lookup value within a one-dimensional range or array, and you use it…
- Excel MATCH with Multiple Duplicates: How to HandleTo find the position of a value when duplicates exist, the MATCH function returns the first match by default, but you can…
- Excel Lookup Second Match: 4 Formulas That WorkTo return the second (or any nth) match in Excel, use the FILTER function (Excel 2021/Microsoft 365): =INDEX(FILTER(range, condition), n). For older…
- Excel Lookup Value in Two Columns for MatchTo look up a value based on a match in two columns, use INDEX and MATCH with array syntax (pressing Ctrl+Shift+Enter in…
- Excel Left of a Specific Character: How ToTo get text to the left of a specific character in Excel, use the LEFT function combined with FIND or SEARCH. The…
- Excel Left Trim Formula: Remove Characters from StartThe quickest way to left-trim (remove characters from the start of) a text string in Excel is with the REPLACE function: =REPLACE(A1,1,n,""),…
- Excel Left Numbers Only? How to Extract DigitsYes, Excel can extract numbers from a cell that contains text, and the fastest way depends on your version. In Excel 365,…
- Excel INDEX MATCH Returning Wrong Value? FixesIf your Excel INDEX MATCH formula is returning the wrong value, the most common causes are mismatched row/column references, missing exact match…
- Excel INDIRECT to Another Sheet: Formula & TipsTo reference another sheet with the INDIRECT function in Excel, use a formula like =INDIRECT("'"&B1&"'!A1"), where B1 contains the sheet name. This…
- Excel INDEX MATCH with Multiple Row CriteriaTo use INDEX MATCH with multiple row criteria in Excel, combine the MATCH function with an array expression that checks each row…
- Excel INDEX MATCH No Duplicates: How to Return Only Unique MatchesThe short answer: standard INDEX MATCH returns the first match it finds, so to exclude duplicates you must add a helper column…
- Excel INDEX MATCH with Multiple Criteria: Real ExampleThe direct answer: use an array formula like =INDEX(C2:C100, MATCH(1, (A2:A100="North")*(B2:B100="Widget"), 0)) entered with Ctrl+Shift+Enter in older Excel, or the same formula…
- Excel Index Match Multiple Criteria Non Array?Yes, you can use INDEX and MATCH with multiple criteria in Excel without entering it as an array formula (i.e., without pressing…
- Excel INDEX and MATCH Lookup: How to Use ItThe short answer: INDEX and MATCH is a pair of Excel functions that together perform a two-way lookup, letting you find a…
- Excel INDEX MATCH Duplicates: How to Handle ThemYes, Excel’s INDEX MATCH can return duplicate values, but the way it handles them depends on your formula structure. By default, INDEX…
- Excel ISBLANK: Check If a Cell Is EmptyThe Excel ISBLANK function returns TRUE if a cell is completely empty and FALSE if it contains any value, including a formula…
- Excel IFERROR with Search: How to Use ItThe direct answer: wrap a SEARCH (or FIND) function in IFERROR to return a custom message or blank cell when the search…
- Excel XLOOKUP Trim: How to Remove SpacesTo trim spaces inside an XLOOKUP, wrap the lookup value and the lookup array in the TRIM function: =XLOOKUP(TRIM(A2), TRIM(B:B), C:C). This…
- Excel Highlight Unique Duplicates: 2 WaysTo highlight unique duplicates in Excel, use Conditional Formatting with a formula that counts occurrences: select your data range, go to Home…
- Excel Function to Transpose Data (Step-by-Step)The fastest way to transpose data in Excel is to copy the range, right-click the destination cell, and choose Paste Special >…