4 Messages
Digest #3095
Messages
Tue Jun 17, 2014 2:40 pm (PDT) . Posted by:
sinclair.nagy
That worked perfect. Thank you very much for the help.
Tue Jun 17, 2014 3:44 pm (PDT) . Posted by:
racecar00
Hi Randy,
I was able to use the RCHGetHTMLTable formula to retrieve the "settlement" column by copying the formula into other rows and adding the array but I was unable to retrieve the other 3 columns in the table. I tried changing column numbers from 1 to 2, 3, 4. I also tried changing the name or "find begin" portion of the formula to the other column headers with no luck. In each case, the formula came back blank (i.e. no error codes). Would you mind providing an example of the formulas to retrieve the other three columns of the table?
Thank you.
I was able to use the RCHGetHTMLTable formula to retrieve the "settlement&qu
Thank you.
Tue Jun 17, 2014 4:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why are you talking about individual columns? The function returns the
entire table -- all the rows and all the columns -- as long as you
array-enter it over enough columns and rows.
The 1 and -1 parameters aren't column numbers, they are directional items
for the search terms.
On Tue, Jun 17, 2014 at 3:44 PM, agelhausen@... wrote:
>
> I was able to use the RCHGetHTMLTable formula to retrieve the "settlement"
> column by copying the formula into other rows and adding the array but I
> was unable to retrieve the other 3 columns in the table. I tried changing
> column numbers from 1 to 2, 3, 4. I also tried changing the name or "find
> begin" portion of the formula to the other column headers with no luck. In
> each case, the formula came back blank (i.e. no error codes). Would you
> mind providing an example of the formulas to retrieve the other three
> columns of the table?
>
>
entire table -- all the rows and all the columns -- as long as you
array-enter it over enough columns and rows.
The 1 and -1 parameters aren't column numbers, they are directional items
for the search terms.
On Tue, Jun 17, 2014 at 3:44 PM, agelhausen@.
>
> I was able to use the RCHGetHTMLTable formula to retrieve the "settlement&qu
> column by copying the formula into other rows and adding the array but I
> was unable to retrieve the other 3 columns in the table. I tried changing
> column numbers from 1 to 2, 3, 4. I also tried changing the name or "find
> begin" portion of the formula to the other column headers with no luck. In
> each case, the formula came back blank (i.e. no error codes). Would you
> mind providing an example of the formulas to retrieve the other three
> columns of the table?
>
>
Tue Jun 17, 2014 4:45 pm (PDT) . Posted by:
racecar00
My mistake. I tried the same formula for all columns and it works.
Thanks
Thanks
Tidak ada komentar:
Posting Komentar