Forum Discussion
MasonF2265
May 03, 2021Copper Contributor
IF function for Pivot Table
Hi everyone, I am trying to run a semi-complex code in excel and am having difficulty. I created a pivot table with people's information (picture 1) and want to run a function that will scan thr...
SergeiBaklan
May 03, 2021Diamond Contributor
If Applicant Name is separate list I'd add it to data model in addition to main source, build relationship and returns result as another tabular PivotTable or like.
Another variant us to use cube functions, first what google returned Cube Formulas - The Best Excel Formulas You're Not Using - Macrordinary