Riaan's SysAdmin Blog

My tips, howtos, gotchas, snippets and stuff. Use at your own risk!

MSExcel

Excel Advanced Filter

Filtering systematically through a lot of data you may need to slowly exclude rows one by one based on your findings or root cause process. I used advanced filters to accomplish this.

Examples here:
https://support.office.com/en-us/article/Filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b#bmexample5

After applying a filter with:

  • excluding 192.168.38.103 and
  • excluding Destination Ports 215 and 217 and
  • showing only rows with bytes > 500 000

Use Data -> Advanced Filter and Select the correct ranges

 

admin

Bio Info for Riaan