Do you have an idea for a blog post? If you have a request, then add a comment, if it fits in with what I know about I’ll try and do a post on it. If you want to write the post your self let me know!!!
Lets see how this goes!
(Dick, I will not blog about if statements!!!)
Hi Ross,
How about comparing the speed of the following functions on Large Data (60K Rows)
Single Conditional and Multiconditional
1) Array Entered Sum
2) Sumproduct (All Syntaxes – *, –, N() )
3) DSUM
4) SumIF(s)
Single criterial Look up (Item available at the bottom of the table) to pick an adjacent Number
1) VLOOKUP
2) Match/Index
I have created a spreadsheet and am using your MIE Timer addin.
It throws up some suprising results, I could e-mail the workbook to you want.
Oh…Also
Sum (A:A) v/s Sum(DynamicName)
Hi Sam thanks,
Do it!
Ross,
What did happen with You and VSTA? How about some posts about Tables/Lists in Excel 2007?
Kind regards,
Dennis
What happen to me and VSTA! It’s not my fault ;-)))) I do try to get some info about VSTA, I do searches from time to time and send e-mails to MS, but I never get anything back – I get the distinct feeling that MS have abandoned VSTA and just not told anyone!
I’ll have a look at tables, I have never used them myself, so will be intresting to learn
Sam have you end me that workbook yet? ;-)
Ross
Yes, I wouldn’t be surprised if MSFT has put VSTA aside. I wonder what the new IDE in Excel will be based on.
Kind regards,
Dennis
Ross Could you please send me a test mail. so that I can send you the Calculation file
[...] response to my blog post “Request an Excel blog post” was not stellar! But 2 people did request things. XL Dennis (aka Dennis Wallentin) asked about [...]