Obewan
Board Regular
- Joined
- Aug 25, 2021
- Messages
- 68
- Office Version
- 365
- Platform
- Windows
I have the following:
AY = a list of codes (i.e. unique identifiers)
BM:BR - columns of data
In BS I have a formula as follows which I can copy down that column (starts on row 7):
=COUNTIFS($AY$7:$AY$100000,$AY7,$BN$7:$BN$100000,">"&BN7)+1
This works and ranks all numbers in column BN according to correpsonding code in AY
What I want to do is extend this formula so it covers all data in columns BN:BR for the code - I changed the formula to
=COUNTIFS($AY$7:$AY$100000,$AY7,$BN$7:$BR$100000,">"&BN7)+1
but just get an error message #VALUE!
Any suggestions?
Thanks in advance
Seamus
AY = a list of codes (i.e. unique identifiers)
BM:BR - columns of data
In BS I have a formula as follows which I can copy down that column (starts on row 7):
=COUNTIFS($AY$7:$AY$100000,$AY7,$BN$7:$BN$100000,">"&BN7)+1
This works and ranks all numbers in column BN according to correpsonding code in AY
What I want to do is extend this formula so it covers all data in columns BN:BR for the code - I changed the formula to
=COUNTIFS($AY$7:$AY$100000,$AY7,$BN$7:$BR$100000,">"&BN7)+1
but just get an error message #VALUE!
Any suggestions?
Thanks in advance
Seamus