Add another column to simple macro, to find more data.

Hello all,

In this sample sheet I have a macro called Test10DISTTIMEx3. There is a quick button at top of sheet. Ultimate test is on a 620,000 row sheet.

What the macro does is looks at every different name in col AH, then looks in col Q for each distance, then looks in col AM and then results in
cols BJ:BL the last three times that were run but only for each different distance.

I have made a macro that can go up to 50 cols wide, but I want to add a second and third, even a forth layer to this macro. Have tried but failed.

When I say layer, this one first looks at col Q distance but now I want to add in col AB.
So results in cols BJ:BL would result any distance and condition, then I would like to make another macro with a third layer and use col AC.

If this can be done, hopefully I can figure out how to add a third layer or col.
In theory, if a col got added to this macro, the amount of results should reduce quite dramatically.

But as I say I'm looking to just add one col at a time.
Thanks.

Hello @I need excel help. Maybe I misunderstood you. But try the following modification of your code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

A macro per condition (assuming I have understood your requirement)

One more:

Please Login or Register  to view this content.

Thanks, MikeVol and John, I have quickly tested all four macros out and I can see they all work perfectly.

Let me do some testing over next few days and I will return. Just have seen Bens come thru as well, so will return.
Thanks.

This post is solved, thanks to all who helped.

Glad to help: thank you for the rep and feedback.