Try Pivot table
Try Pivot table
Never use Merged Cells in Excel
Thanks zbor
How I am looking to set the report up is have a drop down menu on a separate tab that will search either the Area or Site, the results will only show that area or sites results(that have been selected by the user) but will show a number of different KPI's for the selected area or site as well as say the last 6 months results for the chosen Area or site.
The pivot table looks like it could offer this but I cant seem to get my head around how.
I have added some detail next to your pivot table to show how I am looking to set this up.
Cheers
Last edited by Beach Walker; 03-19-2014 at 10:57 PM.
Which column do you want to get result? Is that Column F? and with criteria Area, KPI, and Month?
azumi yes I'm looking to get the result from column F in sheet 1, with the criteria searched 'Area' or 'Site'(both of these will be on the same drop down menu), this search will then populate against the 'KPI' and 'Month'.
Hope it helps, please see the file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks