Users

[Smitty]

Can't live with 'em; can't bludgeon 'em to death, cut their bodies into small pieces and bury 'em under wasteland.

When I quit being a cowboy, and went into the coat and tie world I was on an interview and had a VP of Operations ask me how I thought I could transition from managing cows to people. I told him: "Management's easy, it's just the product that's different. With cows you make them go where you want by making them think that's where they want to go, and you can do the same with people". He asked what you do if you have problems with that in ranching and I said "you shoot them, and eat them."

I got the job.

Edit - FUBAR: should have been "that's where they want to go", not "that's where you want to go"

 

[MrKowz]

When I quit being a cowboy, and went into the coat and tie world I was on an interview and had a VP of Operations ask me how I thought I could transition from managing cows to people. I told him: "Management's easy, it's just the product that's different. With cows you make them go where you want by making them think that's where you want to go, and you can do the same with people". He asked what you do if you have problems with that in ranching and I said "you shoot them, and eat them."

I got the job.

 

[repairman615]

...mahoosive...

I am sooo guilty.

 

[Ruddles]

Yeah, me too sometimes. I even wrote a bit of code which takes a series of formulae in multiple columns and combines them into a single huge formula!

I reckon that's okay though, as long as you don't destroy all traces of the individual formulae just in case you need to tinker with them in the future.

Although I usually do...

 

[Joe4]

I usually try to avoid massive formulas. If a formula gets too big, I like to convert it to a UDF where I can document it and follow its flow a bit easier.

 

[diddi]

I usually try to avoid massive formulas. If a formula gets too big, I like to convert it to a UDF where I can document it and follow its flow a bit easier.

Agree with this. I think it is a terrible failing of excel to actually allow users to construct these horrible convoluted behemouths of formulae in the first place. wouldn't it be great if you could apply a subroutine to a cell directly? much easier to debug.