Creating a summary table from one main table

**fmoraye** · 12-02-2020, 10:16 AM

Hello guys, need some help here, hope someone is able to assist me

So i have a master table with data, lets say on the rows I have the different types of activities and on the columns the different types of workers. The data that populates the table just shows me what amount of each type of worker i need for each type of activity.

I created a drop down list "menu" with data conditioning using as data the type of activities, and what i need is that when a certain activity is selected, for example activity one, it will only bring back to a new smaller resumed table those workers that are actually needed and their quantities.

I have attached a small sample file for better undestanding.

Thank for the help in advance and hope to hear from someone soon.

**Glenn Kennedy** · 12-02-2020, 11:26 AM

Hi. Try this (see sheet for context), in H10:

=IFERROR(INDEX($1:$1,AGGREGATE(15,6,COLUMN($B$1:$F$1)/(INDEX($B$2:$F$6,MATCH($H$9,$A$2:$A$6,0),)>0),ROWS($1:1))),"")

and this in I10:

=IF(H10="","",VLOOKUP($H$9,$A:$F,MATCH(H10,$A$1:$F$1,0),FALSE))

**fmoraye** · 12-02-2020, 09:34 PM

Thanks so much Glenn!! It works perfectly!

I will need to deepen my knowledge on this aggregate formula, but thank you so much for the input on that concept.

Be well!

Creating a summary table from one main table

LinkBack

Thread Tools

Rate This Thread

Display

Creating a summary table from one main table

Re: Creating a summary table from one main table

Re: Creating a summary table from one main table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating a summary progress table from update table

Creating a summary table in VBA

Creating rolling summary table

Creating a summary table from another table

[SOLVED] Creating Tables from a main table that is updating from an external source.

Creating a summary table using formula

Creating Summary table from one workbook to another

Bookmarks

Bookmarks

Posting Permissions