2 Replies Latest reply on Nov 24, 2017 10:10 PM by Tushar More

    How to compare data in multiple Excel tabs?

    samuel.campbell.1

      Hi everyone,

       

      Basically I'm trying to use this data set here and I want to compare the 'Mkt Cap £m' column of everyone single tab in the excel spreadsheet (January to December) so I can see how the company's market cap has changed over the year. What's the best way to do to this? I've tried to use SQL's UNION ALL to make a new column that categorizes the tabs, but it hasn't worked at all. The packaged workbook included on this post (version 10.4) is something else I've tried, but it doesn't seem to work either. How to I achieve this? Thank you.