Senin, 01 Desember 2014

[smf_addin] Digest Number 3254

4 Messages

Digest #3254

Messages

Sun Nov 30, 2014 3:12 pm (PST) . Posted by:

blkruyne

I imagine that other members of this group may have struggled with and solved the following problem.


I have a spreadsheet with 10 columns A through J. In the 1000+ fully populated rows, various values appear in each cell. I seek to identify - on a row by row basis - whether the highest number is in column A, B, C etc.


I have tried nested IF function, but that became too large. Ideally once I know how to identify the column which has the highest value in a particular row, I would like to explore whether I can use the same formula to identify the second highest ( etc?).


The result ideally would be that on Row X, where the values are respectively 2,4,5,3,1,7,9,8,10,6, that in the next two columns the formula produces "I" , "G".


Can anyone help me further with this?


Thanks


Bernard

Sun Nov 30, 2014 3:34 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

This works, as long as you have no ties:

=MID("ABCDEFGHIJ",MATCH(LARGE($A2:$J2,1),$A2:$J2,0),1)
=MID("ABCDEFGHIJ",MATCH(LARGE($A2:$J2,2),$A2:$J2,0),1)

On Sun, Nov 30, 2014 at 2:55 PM, blkruyne@... wrote:

> I imagine that other members of this group may have struggled with and
> solved the following problem.
>
> I have a spreadsheet with 10 columns A through J. In the 1000+ fully
> populated rows, various values appear in each cell. I seek to identify - on
> a row by row basis - whether the highest number is in column A, B, C etc.
>
> I have tried nested IF function, but that became too large. Ideally once I
> know how to identify the column which has the highest value in a particular
> row, I would like to explore whether I can use the same formula to identify
> the second highest ( etc?).
>
> The result ideally would be that on Row X, where the values are
> respectively 2,4,5,3,1,7,9,8,10,6, that in the next two columns the formula
> produces "I" , "G".
>
> Can anyone help me further with this?
>

Sun Nov 30, 2014 3:16 pm (PST) . Posted by:

hedgefundit

Hi,


I was wondering if anyone had done any work on tapping into the data on http://paststat.com/ http://paststat.com/


Specifically I am trying to get the data on historical gaps after earnings releases found on this page;


http://paststat.com/stat/earningsym.php?sym=NFLX http://paststat.com/stat/earningsym.php?sym=NFLX



It looks like fairly straightforward table data with the symbol being passed in a query string, but I am no genius with this stuff. The site has some great data that looks worth adding.



Sun Nov 30, 2014 3:45 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You can grab the two tables with:

=RCHGetHTMLTable("http://paststat.com/stat/earningsym.php?sym=NFLX
",">Strategy",-1,"",1)
=RCHGetHTMLTable("http://paststat.com/stat/earningsym.php?sym=NFLX",">Earnings
Date",-1,"",1)

On Sun, Nov 30, 2014 at 2:32 PM, drobertson123@...wrote:

>
> I was wondering if anyone had done any work on tapping into the data on
> http://paststat.com/
>
> Specifically I am trying to get the data on historical gaps after earnings
> releases found on this page;
>
> *http://paststat.com/stat/earningsym.php?sym=NFLX
> <http://paststat.com/stat/earningsym.php?sym=NFLX> *
>
> It looks like fairly straightforward table data with the symbol being
> passed in a query string, but I am no genius with this stuff. The site has
> some great data that looks worth adding.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 03.29

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)