Forum Discussion
Vesperwind
Oct 10, 2023Copper Contributor
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...
Vesperwind
Oct 11, 2023Copper Contributor
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 much
Insn't there in your opinion a way to express the list by using a formula instead of coding?
Thank you very much
SergeiBaklan
Oct 14, 2023Diamond Contributor
Above is the formula which you could insert into the formula bar.