Forum Discussion
Sorting out data from a column
Luis Serpa I suggest you look into Power Query as demonstrated in the attached example. In general it's not a good idea to insert empty rows in data sets to hold calculations relating to sub-sets of the data. In your case averages and medians per month.
First of all, based on the text, I can recommend inserting the columns into a table and using filters to display the data as desired.
For more and precise information, please add more information.
Which operating system?
Which Office version?
Where are the files stored?
(OneDrive, Sharepoint, hard drive, USB, etc.).
Insert the files (without sensitive data).
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Hi NikolinoDE, many thanks.
OS: Windows 10
Excel version: H&S 2019
Fil'e attached. It's public data, no sensitive info.
Tanks
Luis
Crear o eliminar una lista personalizada para ordenar y rellenar datos
In the attached file the example with the table.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
- Thanks, NikolinoDE. Will try it tomorrow.
Cheers
LuisLuis Serpa I suggest you look into Power Query as demonstrated in the attached example. In general it's not a good idea to insert empty rows in data sets to hold calculations relating to sub-sets of the data. In your case averages and medians per month.
- PS - Until "Sep 06" it's what I have done manually. Thereafter it's the original file.