Hi,
Is there any formula or function how to (semi-)automatically delete all sub-groups rows(and leave only main data)?
excel outlining.png
Eg I have the following rows:
total revenue
revenue in Europe
revenue in Nordic
revenue in Rest of the world
I have created groups. Now I need to send this report in Excel file to my colleagues and I would like to show them only the total rows (tabel2 in attached picture). Do I have to delete the detail data rows one by one manually or there is some helpful function for doing that (or for selecting such rows together).
Thanks in advance!
Reena
Bookmarks