Unique Vstack Subtotal on two filtered tables

**jlschae154** · 10-02-2023, 01:01 PM

Hi,

I'm trying to get a spilled array that has unique values from two different table columns. The issue I'm having is using the subtotal function so that when I filter one or both tables the spill adjust to only show visible rows. Plese see attached

Thanks!

**Fluff13** · 10-02-2023, 01:07 PM

Create a helper column on each table with

Formula:

Please Login or Register  to view this content.

and then you can use

Formula:

Please Login or Register  to view this content.

**Bo_Ry** · 10-02-2023, 01:13 PM

Please try
=LET(f,LAMBDA(x,FILTER(x,MAP(x,LAMBDA(y,SUBTOTAL(3,y))))),UNIQUE(VSTACK(f(Table1[Animal list 1]),f(Table2[Animal list 2]))))

**jlschae154** · 10-02-2023, 01:35 PM

Awesome sauce TY

**Fluff13** · 10-02-2023, 01:47 PM

Glad to help & thanks for the feedback.

Unique Vstack Subtotal on two filtered tables

LinkBack

Thread Tools

Rate This Thread

Display

Unique Vstack Subtotal on two filtered tables

Re: Unique Vstack Subtotal on two filtered tables

Re: Unique Vstack Subtotal on two filtered tables

Re: Unique Vstack Subtotal on two filtered tables

Re: Unique Vstack Subtotal on two filtered tables

Thread Information

Users Browsing this Thread

Similar Threads

Subtotal Sumifs + filtered fields.

[SOLVED] Subtotal a filtered range grrrr

Counting filtered cells using SUBTOTAL

Count filtered cells using SUBTOTAL

Subtotal a filtered range

How do I include filtered out numbers in a SUBTOTAL?

How do I insert a filtered subtotal into overall summary

Bookmarks

Bookmarks

Posting Permissions