Get instant live expert help on I need help with parentheses and periods
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am using an indirect reference to text with parentheses in it. How can I format it to recognize the parentheses as simple text and not cause a #ref! error.
formula looks like this:
=if(isnumber(index(indirect($P38&"!1:1048576),match...
Solved by S. L. in 25 mins
I need help implementing changes to and sdf downloaded file that has a specific format that needs to be followed. I need to be able to transpose and implement parentheses and semicolons along with changing the 9 digit number within the parentheses. For example I would like to change this
((492980625;);); ((504863335;);); into this ((898980625;);); ((604863345;););
Also if I have the above numbers running down a column, I would like to implement the parentheses & semicolon format into a single cell.
Hopefully I explained this problem well enough, I believe if I was able to share my screen it would be more understandable.
Thanks
Solved by T. H. in 30 mins
24 time periods on page with two columns of data...need chart showing rolling 12 periods
Solved by A. J. in 19 mins
Using vlookup for tables across time periods
Solved by V. H. in 18 mins
I need to do a forecast regression analysis on excel given 11 periods, and sales numbers
Can you help
Solved by B. A. in 20 mins