快速循环遍历筛选列表的方法？

I have a sheet with a large number of auto-filtered rows (>200,000). I'm trying loop 'upwards' through a column until I find the first cell that's different from the current cell. I can loop 'downwards' through through visible cells by using:I have a sheet with a large number of auto-filt