Excel advanced filter
wordpress meta
title: 'Excel Advanced Filter'
date: '2017-01-03T09:39:26-06:00'
status: publish
permalink: /excel-advanced-filter
author: admin
excerpt: ''
type: post
id: 1018
category:
- MSExcel
tag: []
post_format: []
title: 'Excel Advanced Filter'
date: '2017-01-03T09:39:26-06:00'
status: publish
permalink: /excel-advanced-filter
author: admin
excerpt: ''
type: post
id: 1018
category:
- MSExcel
tag: []
post_format: []
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
