Tips. Others.(Microsoft Excel)
Contents
- 1. Data Validation
- 2. Formulas
- 2.1. Date operation
- 2.1.1. How to calculate dates.
- 2.1.2. How to display the day of the week automatically from the date.
- 2.1.3. How to get the last business day of the month.
- 2.1.4. How to use the AVERAGEIFS function to calculate on the condition of “Containing a specific string".
- 2.1.5. How to use the SUMIFS function to calculate on the condition of “Containing a specific string".(Microsoft Excel)
- 2.1.6. How to use the COUNTIFS function to calculate on the condition of “Containing a specific string".(Microsoft Excel)
- 2.1.7. How to treat wildcards as normal characters in the COUNTIFS function.
- 2.1.8. How to treat wildcards as normal characters in the COUNTIFS function.
- 2.2. Cell operation
- 2.3. Text operation
- 2.3.1. Text comparison. Exact and partial matches.
- 2.3.2. How to reverse text.
- 2.3.3. How to extract only numbers from text.
- 2.3.4. Formula to split text into cells one character at a time.
- 2.3.5. Formulas to remove multiple types of characters from cell text.
- 2.3.6. Formulas to sort text in cells.
- 2.3.7. Formulas to extract text from a cell every specified number of letters.
- 2.3.8. Formulas to randomly reorder a range of cells.
- 2.3.9. Formula to randomly extract a specified number of cells from a range of cells.
- 2.3.10. How to replace multiple texts with the SUBSTITUTE function.
- 2.3.11. Formula for extracting URL parameter values.
- 2.3.12. How to search for newlines in a cell with the FIND function.
- 2.4. Aggregate function applications.
- 2.1. Date operation
- 3. ChatGPT