- Income Tax Calculator
- Match Multiple Text Criteria
- List All Sheet Names Formula
- Find a Match in All Sheets
- Count Between Dates
- A Game of Bingo
- Using Indirect to Sum Data
- Partial Cell Match
- Hightlight Odd and Even Numbers
- Rank Based on Condition
- Find Duplicates in List
- Prevent Duplicates Entries in Excel
- Cascading List with Formula
- Lookup Row and Header
- Lookup Left Most Value
- Conditional Formatting Traffic Light
- Count Text in Cell
- Filter with Formula
- Sum YTD Data
- Transpose Range to Single Column
- Sum Based on Sheet Name
- World Clock Conversion in Excel
Common and Quirky Excel Problems
The articles in the following segment are non-VBA solutions to common and quirky Excel problems. There are a lot of basics which are left off this list. I have chosen to focus on the things I found interesting. I plan to add to this list of articles as I am continually finding new and interesting problems.
Native Excel
