David W 123
New Member
- Joined
- May 14, 2020
- Messages
- 9
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello and many thanks for reading this
I'm trying to create a formula for column E, which would rank based on 3 criteria (year, city name and sunshine days). The actual data is several hundred rows long. If 2 or more cities have the same number of days within a single year (eg Paris and London in 2023), I would want a unique rank - perhaps based by alphabetical order of the city name but not fussed.
Hoping someone can help
Thanks,
David
I'm trying to create a formula for column E, which would rank based on 3 criteria (year, city name and sunshine days). The actual data is several hundred rows long. If 2 or more cities have the same number of days within a single year (eg Paris and London in 2023), I would want a unique rank - perhaps based by alphabetical order of the city name but not fussed.
Hoping someone can help
Thanks,
David