Oooo.... I've got an awesome one that automatically adjusts for changes in the spreadsheet with no changes to the code. Have done a presentation on it a couple of times. I'm almost done with one for RAND(X) to add to David Poole's. Trying to get back into writing articles on a bit more regular basis and whether or not anyone picks up on this one, I'll also take this one on.
Shifting gears, I still can't paste in the contribution center. Am I the only one with that problem? If so, any hints on what might be wrong with my machine.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs