“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Countif query
On the sheet Call File in column R I need it to reference the site name in the other sheet and to check in Column V if it shows Non Response

Solved by E. W. in 12 mins

=COUNTIF(Candidates!H2:H950,"R-29292") & (Candidates!I2:I950,"Phone Interview") This doesn't work, but hopefully you can see what I am trying to achieve? Please help!

Solved by T. L. in 26 mins

I need to lock a table reference in an index, match function.
E.g. =INDEX(R[241]C[-8]:R[377]C[-5],MATCH(RC[-8],R[241]C[-8]:R[377]C[-8],0)+0,4)
I do not want to change R[241]C[-8]:R[377]C[-5] or R[241]C[-8]:R[377]C[-8] when I drag the formula down

Solved by X. H. in 23 mins

Type in the R square of my model ( Hint: R square after first iteration) ?

Solved by A. L. in 20 mins

Need help with percentage rank excel. I have a formula that is finding rank even when filtered. Now I need to turn that rank into a percentage, 1-100, even when filter also. The formula for the rank is =SUM(IF(SUBTOTAL(103,OFFSET($R$2:$R$1022,ROW($R$2:$R$1022)-ROW($R$2),0,1))>0,IF(R2>$R$2:$R$1022,1)))+1

Solved by E. J. in 24 mins