Minute 06:00 — 07:00

almost half of this pretty close and so it’s almost half this one again you know it’s not used very often i you don’t see these a lot to be honest you just don’t but if you do see it that’s how you use it that’s how it can be done again pretty easy as i just showed a second ago if you want to clear the rules you can clear from the selected cells that’s what we’re doing so i have column g selected and i’m going to i’m going to clear that if you want to clear the rules the entire sheet you can do that as well so it would affect every single column and row we’ll just do this for now so now let’s go look at the top bottom rules so this is the top 10 items top 10 bottom 10 items bottom 10 percent above average and below average and they’re going to do exactly what you think they are going to do if you select above average it is going to select or highlight the cells that are above the average in column g so let’s look at the salaries that are above average all right and so

the ones that are at the very top are michael scott’s toby flendersons and dwight schrute no shock there i believe the average is somewhere around like 48 500 or something so i think this one just is just below it and so all these other ones are below average and that’s just because you know michael scott and dwight schrute are and toby are kind of bringing up that average quite a bit so everyone else is going to fall beneath that and so at a super quick glance you’re able to just highlight the cells and you’re able to see who is above