[TABLE="width: 500"]
<tbody>[TR]
[TD]YEAR
[/TD]
[TD]CLIENT
[/TD]
[TD]STATION
[/TD]
[TD]STATIONCNT
[/TD]
[TD]STATIONCNT RANK
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]A
[/TD]
[TD]CHI
[/TD]
[TD]8
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]A
[/TD]
[TD]LAX
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]A
[/TD]
[TD]DAL
[/TD]
[TD]7
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]A
[/TD]
[TD]SFA
[/TD]
[TD]25
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]A
[/TD]
[TD]NYO
[/TD]
[TD]8
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]B
[/TD]
[TD]SFA
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]B
[/TD]
[TD]CHO
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]B
[/TD]
[TD]CHI
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]B
[/TD]
[TD]LAO
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]B
[/TD]
[TD]LAX
[/TD]
[TD]23
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]B
[/TD]
[TD]NYA
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to rank client file count by year by station.
I normally use SUMPRODUCT if there is only two fields (ie:CLIENT & STATIONCNT) but now have a third column, YEAR, that I need to include the ranking.... Can someone help me with this formula?
<tbody>[TR]
[TD]YEAR
[/TD]
[TD]CLIENT
[/TD]
[TD]STATION
[/TD]
[TD]STATIONCNT
[/TD]
[TD]STATIONCNT RANK
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]A
[/TD]
[TD]CHI
[/TD]
[TD]8
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]A
[/TD]
[TD]LAX
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]A
[/TD]
[TD]DAL
[/TD]
[TD]7
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]A
[/TD]
[TD]SFA
[/TD]
[TD]25
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]A
[/TD]
[TD]NYO
[/TD]
[TD]8
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]B
[/TD]
[TD]SFA
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]B
[/TD]
[TD]CHO
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2018
[/TD]
[TD]B
[/TD]
[TD]CHI
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]B
[/TD]
[TD]LAO
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]B
[/TD]
[TD]LAX
[/TD]
[TD]23
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019
[/TD]
[TD]B
[/TD]
[TD]NYA
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to rank client file count by year by station.
I normally use SUMPRODUCT if there is only two fields (ie:CLIENT & STATIONCNT) but now have a third column, YEAR, that I need to include the ranking.... Can someone help me with this formula?