I previously asked a query on Filtering by a value in a Row, rather than a column:
"I would like a way, if possibly, to filter through this by ROW, rather than Column.
For example, in each group we have a Row labelled Responsibility Application. I want to Filter by Responsibility Application ."
This was answered perfectly by user: byundt
Attached is a working example: ExpertsExchangeExample2Q28363142.xlsm
This solution works perfectly for a dataset of about 5000 rows or less. It takes 40-50 seconds to calculate, but works and is usable.
However, I have been given the same task on a file with 25,000 rows. This solution of filtering by Row causes Excel and the laptops in question to almost break down, so unfortunately can be used.
Can anyone, byundt included, come up with a way to run this or a solution that will work on very large data sets?