Channel: MrExcel.com
Category: Howto & Style
Tags: excelmrexcelfind true and nearby recordsmichelemicrosoft excelbill jelenusing advanced filter in excelfind all in excel
Description: Michele has 46000 rows of data. Each ID has several records in a row. Many records are marked as "Changed". When there is a change, Michele needs to check the record marked, plus the matching IDs just above and below. In this video, I try Find All and 2 Advanced Filters. I bet you have something better.