Excel Help Please

former_trader · February 27, 2015, 11:45pm

I can’t wait to read the minutes.

jeffgoldblum · February 28, 2015, 12:27am

Regarding the original question, why not just use Flash Fill (if you’re using a later version of excel)? Type a few tickers,hit a button, then it’s done. There’s no need for a formula. Sounds like my first post is a winner…

igor555 · February 28, 2015, 12:28am

bchad:

I personally was in favor of having a section for excel and other tool-type questions (i.e. it could also include R, Python, Matlab, VBA, “where do I find X data,” “how do I do X calculation, but not in an exam context” questions). At the same time, the number of forums had increased a lot, and we didn’t want to balkanize the conversation too much.

Also, there was the thought that if all the useful stuff (Careers, Investment/Macro, and now Tools) were in separate forums, then WC would have nothing to talk about other than things like nofap and the power of oneness and how much to tip strippers and stuff. To some extent (a large extent?), that has happened. But people who want an excel tip have to come here to get it.

The challenge, as jmh530 brought up, is that most people wouldn’t go to that forum unless they had some issue they wanted to ask about, so the people who answer those kinds of questions would either have to have an issue of their own, or just be fortunate enough to look in at the right moment.

On the other hand, the Investments forum is livlier than it has been in a while, so maybe a tools.

We have a board meeting coming up, it sounds like a topic to discuss.

So put it in the Feedback forum if you want this!

is it at hooters again?

Analti_Calte_Equity · February 28, 2015, 1:42am

excelopedia.com is the best

rawraw · February 28, 2015, 2:54am

I was being facetious

You should never merge cells. There is a formatting option that allows the cells to appear merged without actually merging them. This is almost always a better option. It screws up formulas and things otherwise

http://blog.contextures.com/archives/2014/04/10/center-headings-without-merging-cells/