-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
bottom 10
-
J
Conditional Formatting for bottom 10 values
Hi All, I have a spreadsheet of hours worked by an agent compared to their expected scheduled hours, and then expressed as a percentage. What I would like is to highlight the bottom 10 agents - but ignore those with a 0 value. If they dont work that week I dont want them highlighted. Using...- jontyoc
- Thread
- bottom 10 format
- Replies: 1
- Forum: Excel Questions
-
S
Conditional Formatting - Ignoring 0 and #N/A using bottom 10% rule.
Hi Everyone I really hope you can help me. I have a range of data which is populated using a vlookup from another spreadsheet. Within this data I have numbers ranging from 0-54. The 0's appear as '-' because that's how they are fedback. I want to conditional format this set of data, to...- SourNerd
- Thread
- bottom 10 conditional formatting
- Replies: 4
- Forum: Excel Questions
-
M
Top 10 And Bottom 10 Items in the Same, One PivotTable Excel 2007
I need to show on PivotTable Excel 2007 both Top 10 And Bottom 10 Items, in the same, only one PivotTable I was wondering is it possible to show it in one PivotTable. I know how to show it just for Top 10 or Bottom 10, but I need to show both Top 10 And Bottom 10 Items. Maybe I was missing...- Myproblem
- Thread
- bottom 10 pivot table top 10
- Replies: 6
- Forum: Excel Questions
