Wizard’s tips by email
Search this site
Topics
- Advice (11)
- Formulae explained (12)
- General (8)
- How to (33)
- Quick tips (18)
- Tools (8)
- Uncategorized (5)
Tags
- ACOS
- ADDRESS
- Chart
- COLUMN
- CONCATENATE
- Conditional format
- COS
- COUNTA
- COUNTIF
- Custom View
- Dates
- Dropdown
- Format
- Formulae
- Frequency
- IF
- INDIRECT
- LARGE
- MAX
- MID
- MOD
- Named ranges
- Navigation
- OFFSET
- Paste Special
- Percentages
- PivotTable
- PivotTables
- PRODUCT
- RADIANS
- RAND
- RANK
- Reference
- Ribbons
- ROUND
- ROUNDDOWN
- Shortcut
- Sorting
- Sudoku
- SUM
- SUMIF
- Syntax
- Text to columns
- Trigonometry
- VLOOKUP
Tag Archives: OFFSET
Dynamic named ranges
Huge power can result from combining the OFFSET function with Named Ranges in Excel. Here's how. OFFSET itself is phenomenally powerful. It allows you to refer to a range of a chosen height and width that is a chosen number … Continue reading