sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 873
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I am trying to rank columns "Q" and "R" based on the ref. "C" and "I"
But getting some error can anyone please help me on this
I am trying to rank columns "Q" and "R" based on the ref. "C" and "I"
But getting some error can anyone please help me on this
Cell Formulas | ||
---|---|---|
Range | Formula | |
E256:E281 | E256 | =MATCH($C256,INDIRECT("'"&$A256&$B256&"'!A:A"),0) |
F256:F281 | F256 | =MATCH($A$5,INDIRECT("'"&$A256&$B256&"'!B"&$E256&":B900000"),0)+$E256-1 |
Q256:R259 | Q256 | =INDEX(FILTER(SORTBY($C$256:$I$281,I$256:I$281),-1),TRANSPOSE(({1;7}))) |
P256:P279 | P256 | =ROW()-255 |
C257:C281 | C257 | =INDEX(Sheet1!F:F,'FS_other MBNA'!AA257,1) |
I256:I281 | I256 | =IFERROR(INDEX(INDIRECT("'"&$A256&$B256&"'!A"&$E256&":IV"&$F256&""),MATCH($H256,INDIRECT("'"&$A256&$B256&"'!B"&$E256&":B"&$F256&""),0)+1,I$5)*100,INDEX(INDIRECT("'"&$A256&$B256&"'!A"&$E256&":IV"&$F256&""),MATCH($H256,INDIRECT("'"&$A256&$B256&"'!B"&$E256&":B"&$F256&""),0)+1,I$5)) |
L256:L281 | L256 | =(INDEX(INDIRECT("'"&$A256&$B256&"'!A"&$E256&":IV"&$F256&""),MATCH($L$254,INDIRECT("'"&$A256&$B256&"'!B"&$E256&":B"&$F256&""),0)-2,L$283)) |
Dynamic array formulas. |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
C256:C281 | Cell Value | contains "offers quick" | text | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
C256 | List | =$AB$256:$AB$268 |