Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =LARGE(IF((tblData[Type]=LPR)*(tblData[Year]=TYEAR)*(tblData[QTR]=QUARTER),tblData[Score]),$A7)
- {=INDEX(tblData[#All],MATCH(1,(tblData[Type]=LPR)*(tblData[Year]=TYEAR)*(tblData[QTR]=QUARTER)*(tblData[Score]=$B7),0),3)}
Add Comment
Please, Sign In to add comment