Hi Gurus,
I am looking to create some automated reports from data in a spreadsheet and was looking for some assistance.
I am concatenating text and data to form the reports and would like to base that commentary on data in cells.
ie- If the total sales have increased this month then list the drivers of the increase.
eg Total Sales increased 5% this month and were driven by an increase of 6% in car sales and a decrease of 1% in bike sales.
Conversely, i would like to put the bike sales first if they were causing the increase.
eg Total sales increased 5% this month and were driven by an increase of 7% in bike sales and a decrease of 2% in car sales.
I am fine with identifying the increase/decrease using isnumber(search), but am struggling to find a way to have excel report in the correct order.
Hope this makes sense.
Cheers,
G
Bookmarks