I have a sheet that has alot of data. I am trying to create a report page or a summary page that makes it a little easier to read the data and be able to present the data. I have formulas using a Match and an Index formula to retrieve data for certain columns (sales, GM, Exp, Bop) for each month depending on the metric i select (highlighted in light blue)
The issue I'm having is if I use a filter for example to selection only K and only UT's then I have blank rows that happen inbetween and it doesn't look good. I don't know if I should use look ups on a speerate worksheet but ideally what I would like to have is if I select S and Sales and IT then thats what will come up but it will be clean and no multiple blank rows between each section.
Can someone help me with this please?
Bookmarks