Excel Formula Tips - All Tips (60 tips)
- Calculating the Week Number
- Calculating the Quarter Number
- Extract the first word in a cell in Microsoft Excel
- Extract the last word in a cell in Microsoft Excel
- Extract all the words except the first in Microsoft Excel
- Extract the first, middle and last name in Microsoft Excel
- Count the number of words in a cell in Microsoft Excel
- Add space between characters and numbers in Microsoft Excel
- Forecasting Daily Budget
- Ignoring Blank Cells when Performing Calculations
- Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks
- Watch Calculation Results Immediately in Excel 2007
- Counting unique entries in a range
- Applying Quick Sum Formula
- Count of uniques among duplicates
- Get adjacent value of a cell having minimum value in a range
- Get filename from path
- Lookup & return Multiple Results
- Personal Notes or Hidden Text in a Excel Formula
- Count filtered cells using SUBTOTAL
- Repeat entries in a column
- Offset function in excel
- Hide excel formulae
- Debug #VALUE Error
- Debug #REF Error
- Debug #NULL! Error
- Debug #NAME? Error
- Debug #N/A Error
- Debug #NUM Error
- Debug #DIV!0 Error
- Setting Excel To Calculate Manually
- Quickly sum non-contiguous cells
- Reference one cell only for date
- ISFORMULA
- Which function to be entered as Array formula?
- XOR function
- IFNA function
- DAYS function
- ISOWEEKNUM
- ARABIC function
- SHEET function
- SHEETS function
- GAMMA function
- WEBSERVICE function
- UNICODE function
- UNICHAR function
- NUMBERVALUE function
- SKEW.P Function
- PHI function
- PERMUTATIONA function
- COMBINA function
- ISO.CEILING function
- BASE function
- RRI function
- MUNIT function
- BITAND function
- BITOR function
- BITXOR function
- BITLSHIFT function
- Decimal Function
»Click here to submit a tip to Excel Formula tips
