Lists Within Tables

[PaulFogel123]

Hello,

I have a list of 28 items divided into 2 categories, "MED" and "SURG." I want to divide each of those two categories into separate Excel tables for analysis. Below each Excel table is a total row. The problem: Each of these 28 items could be in different categories in any given month. So, for example, 15 of the 28 items might be MED and 13 SURG this month, but 13 MED and 15 SURG next month. I could have 28 rows in both tables, but then a bunch of them would be blank, and I don't want any blank rows. I also don't want to use VBA.

The list is attached. Does anyone have a solution to this problem?

Paul

 

[John Jairo V]

Hi @PaulFogel123

Please check file. Blessings!

 

[PaulFogel123]

Hi @PaulFogel123

Please check file. Blessings!

Thanks John,
That sorts out the tables nicely, but the Totals are at the top. That's one solution, but what if I want my totals to always appear at the bottom, right below the last row of each table?

 

[John Jairo V]

but what if I want my totals to always appear at the bottom, right below the last row of each table?

Check the file, please, and comment. Blessings!

 

[PaulFogel123]

Check the file, please, and comment. Blessings!

I think you have it! An elaborate formula, to be sure. Thanks!

 

[NARAYANK991]

Hi Paul ,

Wouldn't a pivot table be convenient ?

Narayan

 

[John Jairo V]

Hi to all!

Refined formulae a little bit, and another options (include @NARAYANK991 idea). Blessings!

 

[PaulFogel123]

Hi Paul ,

Wouldn't a pivot table be convenient ?

Narayan

A PivotTable would work, but I'm trying to fit it into another table, and I want it sortable, and some other options. One way to go might be a PivotTable and then use that as the data source to populate my report, rather than the PivotTable itself act as the report.

 

[PaulFogel123]

Hi to all!

Refined formulae a little bit, and another options (include @NARAYANK991 idea). Blessings!

Thanks, John!