Excel help

[kimchi_chigae]

Chicks dig spreadsheets.

[Big Pimpin]

Chicks dig spreadsheets.

You'd be surprised, my friend... You'd be surprised.

[JTWood]

Can you set up a condition in which if the cell reads #N/A it is replaced with "-" or " "?

Yep...

=IF(ISNA(Formula),"",Formula)

I prefer ISERROR... It works for a broader range of error outputs than ISNA.

[JTWood]

Chicks dig spreadsheets.

Well, chicks dig money, and spreadsheets make me plenty of it, so...

I think you might actually be right.

[RynMan]

I got this one!

Delete the formula from it

Great advice right there.



How did you guys learn so much about Excel? JT....BP?

Just by being old nerds?

[JTWood]

Is 29 old?

I learned a lot of the initial stuff I know about Excel by playing fantasy baseball. Seriously.

After that, my first accounting job required me to massage some data, and I happened to work with a guy that was very good at the actual functions in Excel. When I got promoted to my next position, I volunteered to automate some manual procedures that the finance department was wasting time on. To do that, I had to learn VBA. Excel is great because of that record macro button. I learned how VBA worked by recording myself doing repetitive tasks, and then I started expanding it.

Now, I actually get paid to work in Excel 75% of every day. I do everything from massaging raw data into reports for managers to writing VBA scripts to pull import and format raw XML straight from the web.

And all of this is possible because I am a fantasy baseball geek.

On a related note, I have heard stories of high school classes springing up around the country where the entire class is based around fantasy sports. The teachers use it as a medium to teach the students statistics. Pretty cool, if you ask me (and I know you did).