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!!!)
Related posts:
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 [...]