Using IFERROR and UNIQUE to create a summary table

[BenHornsby2021]

Good afternoon!

I am looking for help with a formula that will generate a 'dynamic' table in Excel. I am building a tracker spreadsheet with a tab to collect data on the issuing of tickets, which records the staff member name in Column A and the number of tickets in Column B per instance.

I also have a dashboard tab, on which I would like a formula to look up the staff name and number of tickets and populate it in a table - this is where 'Staff issuing' and a list of names appears from cell E14. BUT - I can't figure out how to make this total the number of tickets AND make it add a new row automatically if a new member of the team is added to the Master List.

So far, I have tried using =IFERROR(UNIQUE(FILTER(MasterList!$A$2:$A$279....... to try and achieve this but need help. Any advice would be much appreciated.

[oeldere]

With a pivot table. See the attached file.

[dosydos]

in F14 then drag down:

=IF($E14="","",SUMIF(MasterList!$A:$A,$E14,MasterList!$G:$G))

[Fluff13]

Another option that will spill

Please Login or Register  to view this content.