Hello,
I use very old Excel for XP. I am not experienced with VBA in Excel.
I attach a table.hospitals_.xls
I would like to create table of detailed summery.
I am interested about the age of patients depending on the health state (column I is in Czech)... This is the main goal. I want to create tables with min,Q1,Q2,Q3(i.e Quartils),average,max values. But to have it more detailed, I want there tables:
table 1 for both sex
table 2 for male sex
table 3 for female sex
Yet I need to see the states under the tables... Please see the next table to understand the information I would like to see for the specified sex.
I have checked for some existing solutions like here:
vbaexpress.com "Calculating Min,Max,Quartile in dynamic ranges" code in post #8 ...
I thing the code is pretty cool and I could use something similar, but I do not need to work with multiple sheets. I would like to select all input table data and the table sould be added in the active sheet under the selected table.
So I think the main thing to do here is to proccess the data in a Range so that they are limited somehow... Actually two conditions:
1) sex
2) state
And then from the limited Range I need to generate the quartiles... etc.
So can you help with this? Remember, I have old Excel, so I miss many modern functions.