dan_l
Active Member
Here's the problem:
I've got a list. There are two columns, one is states the other is transit routes. So:
[State] [Route]
Illinois A100
Indiana B50
Iowa A100
Illinois A100
Wisconsin A190
Illinois D35
What I need is to be able to specify a state and get the number of unique transit routes associated with that state. I've kind of got this working in a UDF, but it's a massive set of data and the performance is pretty abysmal.
Any thoughts? this feels like a sumproduct or array formula problem, I'm just not sure how to solve it.
I've got a list. There are two columns, one is states the other is transit routes. So:
[State] [Route]
Illinois A100
Indiana B50
Iowa A100
Illinois A100
Wisconsin A190
Illinois D35
What I need is to be able to specify a state and get the number of unique transit routes associated with that state. I've kind of got this working in a UDF, but it's a massive set of data and the performance is pretty abysmal.
Any thoughts? this feels like a sumproduct or array formula problem, I'm just not sure how to solve it.