Extracting results to ExcelA standard technique to further process a Filter-X research, is to extract the result table to an Excel workbook and leverage the capabilities of Filter-X with the maths & graphs properties of Excel.
The process is quite simple. While in Filter-X, select the table with the cursor, open an Excel workbook and paste data in Sheet1. The result would be that also the hyperlinks of Filter-X have been pasted, a thing which you may find somehow unhandy when working with the workseet afterwards. Therefore, select again the whole Sheet1 and go to Sheet2, where you PasteSpecial the data, paying attention to paste only the Values. One may find it practical though to conserve the hyperlink for variable [COMPANY NAME], so as to have an instant access to fundamentals for a company. In this case, go back to Sheet1 copy the column of company names only, and paste (simple paste) it over the respective column in Sheet2.
Many times Filter-X's result tables exceed 100 rows. In this case, you should paste the data to Excel, hundred-by-hundred, paying attention to the numbering of rows. Once you gathered all rows in Sheet1, thereafter the process is not any different from the one described above.
|