Friday, December 23, 2011

yogi_Import From A Table With Data in Variable Position

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Orion77 said:
How to import from a table with data in variable position?
I want to import data from a table in a web page that updates daily. Some days there is no data and I just want to get the last valid data. The table is similar to this:
1/12/2011     25    -    -
30/11/2011    28    -    -
29/11/2011    28    -    -
28/11/2011    28    -    -
25/11/2011    28    -    -
24/11/2011    28    -    -
23/11/2011    39  4000  1560
22/11/2011    27    -    -
I am interested to get "23/11/2011" and "39" since those are the last valid data.
I use 
=ImportHtml(Concat("http://www.boerse-frankfurt.de/DE/index.aspx?pageID=125&ISIN=";"XS0171467854");"table";1)
to get the table, but I can not use INDEX(;;) since I do not know the position of the valid data. I have tried VLOOKUP and FILTER but I do not know how to use them in conjuntion with ImportHtml.
Any help would be appreciated.
Thank you!

----------------------------------
following is a solution to the problem