Messages In This Digest (1 Message)

1a.: Re: Use of SMF Formulas in Excel 2010 Tables From: Ron Spruell

View All Topics | Create New Topic

Message

1a.: Re: Use of SMF Formulas in Excel 2010 Tables

Posted by: "Ron Spruell" hashky@yahoo.com hashky

Fri Apr 20, 2012 8:57 am (PDT)

This was my experience also. I didn't name the table. I just put the Ticker Symbols in C5:C107. I highlighted C5:F107 and then from the Ribbon (which I hate), Insert->Table. Excel Added a header row C5:F5 and named the headers Column1,Column2, etc. The new table was C5:F108. I didn't name the table.

In D6, I wrote the equation
=RCHGetElementNumber(
Then moused to Col C which has the ticker value (MMM). Then I typed in 13862, the code for the company name. Excel populated Column D. It was NOT fast.

The equation in Cell D9, for example, was
=RCHGetElementNumber(C9,13862)

Similar for the rest of the Column, D10 had C10, D11 had C11, etc.

I don't know where the @Ticker came from in Pete's spreadsheet.

Ron

>________________________________
> From: Ron <rlcarr71@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, April 19, 2012 12:50 PM
>Subject: [smf_addin] Re: Use of SMF Formulas in Excel 2010 Tables
>
>
>
>When I created my table (excel called it Table1, rather than TICKER).
>I'm assuming maybe before you where using the named range TICKER for the smfUpdateDownloadTable macro.
>I also experienced the nice results where it automatically applies the formula down every row in the column.
>However, mine was not lightning fast, possibly you had run some Gets earlier and those symbols where still in your cache.
>
>Nice find.
>Ron
>
>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)