Count no. of weeks since best rank

[ironiz]

Hi there,


I have some keyword ranking data that I am trying to find the number of weeks since the best rank. Currently using the no. of weeks reported on minus a match on the best rank. However the issue with this is that the match lookup selects the leftmost minimum value which disregards whether that value appears again in the row.


I have attached the workbook containing an example. Is there a way of being able to use the rightmost minimum (best) rank instead of the default lookup going from the left?



Hi there,

I have some keyword ranking data and am trying to find the number of weeks since the best rank. Currently, I'm using the no. of weeks reported on minus a match on the best rank. However the issue with this is that the match lookup selects the leftmost minimum value which disregards whether that value appears again in the row.

Here is the link to the workbook containing an example https://www.dropbox.com/s/3piizmddxq04v2k/CountWeeksFromBestValue.xlsx?dl=0. Is there a way of being able to use the rightmost minimum (best) rank instead of the default of looking up from the left?

Cheers,

Tom

 

[AlphaFrog]

Try this in P8
=13-MAX(INDEX((B8:N8=O8)*COLUMN(B8:N8)-2,))

 

[ironiz]

That worked a treat. Thanks AlphaFrog