Would be interested to hear more about this. Maybe you could post non-CL specific methods? Or remove all the CL instructions just leaving the general idea behind it?
Yes, I have. It won't fix your problems on it's own. It will give you the tools and the right attitude to fix them though. That's my take on it from experience over the last year and a half.
It's like that old joke about the drowning sailor who kept on praying to God to be rescued. Three boats...
Select everything in your Excel spreadsheet by clicking on any cell and pressing CTRL+A. Then copy it with CTRL+C and open a new file/sheet.
When you paste it make sure to PASTE VALUES. There's an option in Excel to paste only the value which will paste the result of your formula, not the...
Thanks, there might be a lot of collateral damage as I predominantly logged in from my Uni campus! Could accidentally annoy a lot of BHW users by doing this. Probably best if I just let it expire if it hasn't already.
I don't. There's a strong chance it's been deleted as I won't have logged in for at least two years. Also I don't know what it is so I can't log in if it still exists!
To tell the truth I can't remember it otherwise I would have used it to log in!
I wasn't anyone important - I did more reading than posting. Possibly 100-200 posts so nothing extravagant!
Select the cell with the working formula in it. Then drag the corner (I think there's a small black square in the bottom right) down to the bottom of your list. The formula will then modify itself to be applicable to each individual row.
I can't post links yet, but Google "dragging formula down...
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.