Consulting

Results 1 to 19 of 19

Thread: Create Table with quartils

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Dec 2021
    Posts
    58
    Location

    Create Table with quartils

    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •