2 ms·
You can run queries over data in Excel from inside Excel - using the Get External Data option then selecting the spreadsheet you are working on as the source.
by arethuza 13y ago
You can run queries over data in Excel from inside Excel - using the Get External Data option then selecting the spreadsheet you are working on as the source.
However, while investigating this I found that Excel gets quite upset if you import the data from your query into the same location as the source...... :-)