[TABLE="width: 300"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: right"]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]BRANCH
[/TD]
[TD]CLIENT
[/TD]
[TD]FILECNT
[/TD]
[TD]RANK
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]12
[/TD]
[TD]ABRE01
[/TD]
[TD]50
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]12
[/TD]
[TD]AEVA01
[/TD]
[TD]45
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]12
[/TD]
[TD]NIEX01
[/TD]
[TD]46
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]12
[/TD]
[TD]NIEX02
[/TD]
[TD]47
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]12
[/TD]
[TD]CAI00
[/TD]
[TD]29
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]32
[/TD]
[TD]ABRE02
[/TD]
[TD]15
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]32
[/TD]
[TD]AEVA01
[/TD]
[TD]45
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]32
[/TD]
[TD]NIEX05
[/TD]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]32
[/TD]
[TD]NIEX07
[/TD]
[TD]47
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]32
[/TD]
[TD]CAVI00
[/TD]
[TD]40
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
The table above represents the number of files, by client, by branch. I want to rank the FILE COUNT number in descending order, by BRANCH but I do not want to include the client codes that begin with the first four letters NIEX in the ranking.
The RANK column represents the ranking that the formula should create.
Can someone help me with a formula to auto create the ranking in the RANK column?
I appreciate any assistance some one can give me.
Thank you in advance.
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: right"]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]BRANCH
[/TD]
[TD]CLIENT
[/TD]
[TD]FILECNT
[/TD]
[TD]RANK
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]12
[/TD]
[TD]ABRE01
[/TD]
[TD]50
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]12
[/TD]
[TD]AEVA01
[/TD]
[TD]45
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]12
[/TD]
[TD]NIEX01
[/TD]
[TD]46
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]12
[/TD]
[TD]NIEX02
[/TD]
[TD]47
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]12
[/TD]
[TD]CAI00
[/TD]
[TD]29
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]32
[/TD]
[TD]ABRE02
[/TD]
[TD]15
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]32
[/TD]
[TD]AEVA01
[/TD]
[TD]45
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]32
[/TD]
[TD]NIEX05
[/TD]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]32
[/TD]
[TD]NIEX07
[/TD]
[TD]47
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]32
[/TD]
[TD]CAVI00
[/TD]
[TD]40
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
The table above represents the number of files, by client, by branch. I want to rank the FILE COUNT number in descending order, by BRANCH but I do not want to include the client codes that begin with the first four letters NIEX in the ranking.
The RANK column represents the ranking that the formula should create.
Can someone help me with a formula to auto create the ranking in the RANK column?
I appreciate any assistance some one can give me.
Thank you in advance.