New answers tagged

1

The following setup will return the last price for NASDAQ 100 Index (NASDAQ Calculation) A1: http://bigcharts.marketwatch.com/markets/indexes.asp A2: =//tr[contains(.,'NASDAQ 100 Index (NASDAQ Calculation)')]/td[4] A3 Formula: =IMPORTXML(A1,A2) A3 Result: 4,512.54


0

importrange is not going to reorder any rows. It only imports data. The root cause is poor data structure: the second spreadsheet (with expenses) does not carry any information on whose expenses are those. This should not be acceptable data management: each table must have a column that can be used as an identifier. (Ideally, a numeric Id of an employee, ...



Top 50 recent answers are included