May 03 2021 11:58 AM
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 through the pivot table, see if "Adam Doe" exists, if so, see if a city exists, if so, print the value, otherwise print "NA" in the new table (picture 2) The same formula would continue except instead of city, look for state, phone number, email, etc.
Any help would be appreciated! Thank you!
I
May 03 2021 04:07 PM
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