PVR101
asked on
Filtering data table by months
I am looking to filter a data table and its output results which include COUNTIFS functions using excels date filters option.
How can I modify the cells in C27:K42 (HIGHLIGHTED YELLOW) on 'Table' Sheet so that the data changes when i apply a date filter on column B in the 'Metocean Data' sheet for say months may/jun/jul/aug? or indeed a single month so that all dates for these specific month(s) are only included in the countifs fuction calc.
The workbook already allows for filtering based on a specified start and end date but looking to modify so includes just specified month(s) for all the years of data. Ideally I would like to be able to just apply the date filter on the data sheet and the table for occurences update automatically
Also, is there a way to select more than one month when use date filters>all dates in the period>may+june+jul+aug etc as seems to only allow single month selection?
Filtered-Data-Table.xlsx
How can I modify the cells in C27:K42 (HIGHLIGHTED YELLOW) on 'Table' Sheet so that the data changes when i apply a date filter on column B in the 'Metocean Data' sheet for say months may/jun/jul/aug? or indeed a single month so that all dates for these specific month(s) are only included in the countifs fuction calc.
The workbook already allows for filtering based on a specified start and end date but looking to modify so includes just specified month(s) for all the years of data. Ideally I would like to be able to just apply the date filter on the data sheet and the table for occurences update automatically
Also, is there a way to select more than one month when use date filters>all dates in the period>may+june+jul+aug etc as seems to only allow single month selection?
Filtered-Data-Table.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Kyle, thanks for reply and vid which was very helpful. I have sent you a message with a sample sheet with just a couple of small queries and needed to forward sheet to illustrate - hope to hear back from you shortly :)
much appreciated
much appreciated
ASKER
The pivot table appears to automatically list the directions in below format;
E ENE ESE N NE NNE NNW NW S SE SSE SSW SW W WNW WSW
but other tables in my workbook use the following;
N NNE NE ENE E ESE SE SSE S SSW SW WSW W WNW NW NNW
is it possible so when pivot table is created it presents results in similar format ?
In my full workbook I have generated some plots based on the countifs table results for Wind speed categories Vs % Occurence, Wind direction vs % occurences, Period Vs % exceedance, Wind speed knots Vs % exceedance etc. Is it possible to generate any of these using a pivot table?
It seems i need create a new pivot table for each plot as if attempt to create a second plot and select different field list items both plots on sheet will change. Apologies for ignorance re pivot tables - hence queries ?
rgds,