Forum Discussion
Creating a vertical list of people from two pivot tables
Hi, I have 2 pivot tables on the same sheet. Under the "Row Labels" of the pivots I have two lists of people (someone is in the other someone is not). I need a "dynamic" formula to create a ve...
That could be
=LET(
f, UNIQUE(VSTACK(TOCOL(A:A, 1), TOCOL(J:J, 1))),
FILTER(
f,
(ISNUMBER(SEARCH("Label", f)) - 1) *
(ISNUMBER(SEARCH("Total", f)) - 1)
)
)- Hi Sergei, thanks for the reply.
Insn't there in your opinion a way to express the list by using a formula instead of coding?
Thank you very muchAbove is the formula which you could insert into the formula bar.
