Does anyone know if it is possible to highlight a section of data in a spreadsheet and make every number absolute, without having to click on number and press F4?
Could you please sugest a way I could do the following:
I have the following formula
=MarketsPhased!C4*AVERAGE
($C$2/MarketsPhased!$C$2,$C$3/MarketsPhased!$C$3)
basically trying to predict the performance for this month based on an average of previous two months performance.
I will be...
On a monthly basis a sheet of data is inserted into a different worksheet, each worksheet named after the month.
What I want to do is check to see if the data is in these 12 pre-named worksheets and place a value in the cell, like the following...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.