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: Sorting
Breaking rank—differentiating between values that are equal
Challenge: On a dashboard report, show the top five values from a table of data showing the number of respondents. And against these values, provide other data from the same records. At first glance, the above challenge seems rather simple. … Continue reading