Remove >70% efficiency from employee report

D

DPARDY

New Member
Joined
Dec 3, 2009
Messages
41
Office Version
  1. 365
Platform
  1. Windows
Thank you in advance for your time and help.

I have a spreadsheet that I export daily from our system and I have got it to this point. My next step that I am tiring to do is, everyone that has a greater than 70% efficiency (column S), I want to remove/hide all their info from the file. The problem I am having is that the number of jobs varies day to day per person with 50+ employees.

Thanks again.

LR_EmployeeEfficiency.jpg
 
Sort by date Sort by votes

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
You must log in or register to reply here.

Similar threads

O
  • Question
Count only one occurrence of all criteria being met
Replies
8
Views
456
KRice
K
L
  • Solved
Need to find data within a specified range when there are multiple ranges with similar data
Replies
4
Views
296
KRice
K
S
  • Question
Can a macro help create a user hierarchy?
Replies
7
Views
190
Akuini
Akuini
P
  • Solved
Filter and Delete Rows from dataset based on Two Criteria
2
Replies
10
Views
240
Joe4
Joe4
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
262
Insurance Dave
I

Forum statistics

Threads
1,215,139
Messages
6,123,263
Members
449,093
Latest member
Vincent Khandagale

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top