 # Get instant live expert help on I need help with r match function “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to lock a table reference in an index, match function. E.g. =INDEX(RC[-8]:RC[-5],MATCH(RC[-8],RC[-8]:RC[-8],0)+0,4) I do not want to change RC[-8]:RC[-5] or RC[-8]:RC[-8] when I drag the formula down
Solved by X. H. in 23 mins
NEED HELP IN THE INDEX FUNCTION AND MATCH FUNCTION
Solved by T. D. in 18 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
hello i need a help regarding index match function
Solved by M. S. in 23 mins
Hi, I want to create a countdown to show when I go on R&R from work in Iraq. So far I have created a pie chart and separate data that shows how long I have been in country for and also how long I have left until I go on R&R using the required formulas and dates that says when I arrived in country and when I go on R&R. I would like to a function to this that shows when I have less than a month to go for R&R, with the text appearing below the pie chart stating "Less than a Month" when I have reached this time frame, and also I would like the same for when I reach a week or less. Was wondering if you could help on the matter please?
Solved by C. C. in 26 mins