In col A I have subsets and in Col B values. These subsets vary in length (# rows).I'm looking for away to filter the values by using the last value in each subset (cells B5, B10, B14). I'll refer to these as the anchor cells. and only display remaining values ">" or "<" than the anchor cells.
I don't think Advanced Filter or a Pivot Table can do this task? Happy to be proven wrong!