Hi Everyone,
I have you can help me, I need a formula to count the latestconsequetive times a location is in a range.
Example below:
Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct |
London | London | London | Paris | Paris | London | London | London | London | London |
In an ideal world in a cell I would like to return for thecity line, a count of 5 for 5 month of London as the first 3 months should be disregardedas they have been broken by other cities.
Thanks for reading!