Hi,
I have a table that contains all my data and would like to filter it by company into their own tables that will stay up to date with the main table and then hopefully somehow calculate their investment returns (future stage).
I thought Microsoft Query would work but I came across a problem see my other post http://www.mrexcel.com/forum/excel-...-some-columns-i-cant-sum-looks-like-text.html
Thanks
Excel 2010
I have a table that contains all my data and would like to filter it by company into their own tables that will stay up to date with the main table and then hopefully somehow calculate their investment returns (future stage).
I thought Microsoft Query would work but I came across a problem see my other post http://www.mrexcel.com/forum/excel-...-some-columns-i-cant-sum-looks-like-text.html
Thanks
Excel 2010