Counting given amount of consecutives

[Marvo]

Hi Again, I've constructed a formula

=XLOOKUP("W",K:K,B:B,,0,-1)

That works well, it finds the most recent time there was a "W" in a column.

How could I change that formula so that it would look for a given amount of consecutive "W"s please?

I'm thinking maybe of having it refer to a cell $F$5579 with a number in it, then look for that amount of "W"'s.

So if I put a 3 in the reference cell, the formula would then look for the most recent time there were 3 consecutive "W"'s in column K.

Would that be the way to go?

As always any help appreciated and if there's a better way of achieving the desired result I'm happy to be educated.


/?

 

[Marvo]

Here is the image requested. Its a different path than what I got yesterday, it had root in it. Anyway I followed this path, got to excel, once clicked, there is no XLSTART folder.

 

[Marvo]

Tried again, same path, this time an XLSTART folder has appeared, it is empty and there doesn't seem to be a way to input anything in it.

 

[Marvo]

Okay, now I've managed to put the file xI22bb downloaded in the folder. Now what?

 

[Marvo]

Rebooted. NOW its appeared.

 

[Peter_SSs]

Now continue from the 'Usage' heading in the instructions.

 

[Marvo]

Okay. I haven't got anything to post I don't think, we've reached a stalemate in my problem but as soon as I do, I will try it out.

Thank you for the help.

 

[Peter_SSs]

but as soon as I do, I will try it out.

Why not try it out now in the Test Here forum so you investigate some of the options and be more familiar with it when you do need it for a real question?

 

[Marvo]

Okay, will do.