Trying Again... Seeking assistance with criteria based sort and filter.

[xoenix]

I posted prior. However, I could not get the solution I was looking for. I have a spreadsheet w/ approximately 40K lines of data. The data is formatted into 3 columns – employee name; week ending; avg. hours worked.

Is there a way for me to filter this data in such a way that it omits employees who do not have any hours or entries for the prior two weeks? BUT here's the catch. I need to keep those that do without omitting the entries entries for the other remaining weeks. Let me explain.

In the example below, such filtering would only pull Bob Smith because he has hours the week ending 7/28 and the week ending 8/4 (while still keeping the entries for 7/7, 7/14, and 7/21). However, the filtering would omit Mary Moore because she has no hours these dates. Looking for the most efficient way to sort this large amount of data given the criteria above. Any help you can provide would be greatly appreciated and will have my eternal gratitude! Please note that I cannot attach the spreadsheet here. I do not see that as an option.

[TABLE="class: cms_table"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Week Ending[/TD]
[TD]Avg. Hours Worked[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]07/07/19[/TD]
[TD]8.10[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]07/14/19[/TD]
[TD]7.50[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]07/21/19[/TD]
[TD]5.50[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]07/28/19[/TD]
[TD]6.25[/TD]
[/TR]
[TR]
[TD]Bob Smith[/TD]
[TD]08/04/19[/TD]
[TD]8.25[/TD]
[/TR]
[TR]
[TD]Mary Moore[/TD]
[TD]07/07/19[/TD]
[TD]9.00[/TD]
[/TR]
[TR]
[TD]Mary Moore[/TD]
[TD]07/14/19[/TD]
[TD]8.50[/TD]
[/TR]
[TR]
[TD]Mary Moore[/TD]
[TD]07/21/19[/TD]
[TD]7.75[/TD]
[/TR]
</tbody>[/TABLE]


Here's the raw data I'm working with:

https://www.mrexcel.com/forum/redir...auRyw_SXS3TTS2XiO0D1HePzRLJs/view?usp=sharing

 

[Joe4]

Per forum rules, please continue in your original thread here: https://www.mrexcel.com/forum/excel...e-criteria-based-sort-filter-post5321816.html
You actually have a reply there that you never responded to.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).