ExcelBanter - View Single Post - PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic

Harlan Grove

wrote...
and you REALLY think that arrays are that complex?

Apparently they're sufficiently complicated that you haven't been able
to whip up the requested VBA procedure in a week's time. So, no,
they're not complex for me, but there's no evidence to suggest that
they're not too complex for you.

i mean-- seriously harlan.. what are you looking for 'yes, you are
right.. databases can't handle arrays'

No. I'm pretty sure that a competent programmer could handle arrays in
databases. But I'm not at all convinced you can.

spreadsheets can't handle arrays buddy

Really?! I inverted the array I posted in my challence to you last week
before I posted. Seems like Excel can handle that bit of array
processing. You don't seem to be able to, but just because Aaron is
either to ignorant or too stupid to manage it in Access or VBA doesn't
mean that there aren't thousands of high school kids that could.

databases handle 2-dimensional stuff just fine.. and everything you've
ever touched is 2-dimensional by definition..

Sure. Whatever you say.

if you really want the heavy math; you do OLAP

If you (1) have access to OLAP software, and (2) want to waste the time
needed to set up your data in OLAP. And I didn't happen to see any
mention of a matrix inversion function in Microsoft online
documentation for MDX. Care to provide a link?

i mean. .it's got a lot more functions that you spreadsheet dorks are
familiar with

And you're not familiar with.

Yes, I'm sure it can do a lot. I'm just not convinced you can do
anything more than rant. You haven't exactly demonstrated any other
competence.