Filtering Data

[yasmani01]

Hello,

How are you?


I need to filter a table of more that 700000 rows as I describe below. Can you please help me with this?

PLease see sample of the table attached.

I would like to get the number of orders processed per day (E), the number of items per day (I) and the number of different products (H) per day. all that excluding weekends and Holidays.

Thank you very much

[TMS]

I suspect the easiest way would be to insert a Pivot Table. Then it should be easy to count orders and/or products per day. You might need a helper column if you need to filter out weekday and weekend dates.