Forum Discussion
Extract percentage from two columns
Hi everyone! I want to get data from two columns in my workbook. I have one column of vendors and one column stating if they met their requirements or not (yes or no). What I want is a formula ...
That works splendidly, but I forgot to mention that I'm trying to use it regarding data in a pivot table, and then that formula does not work. Help?!
Please:
- Post a picture of your Pivot Table
- Do your run Excel on Windows or Mac?
- If on Windows, is Power Pivot Data Model involved?
- Post a picture of your Pivot Table
- Do your run Excel on Windows or Mac?
- If on Windows, is Power Pivot Data Model involved?
Lorenzo
It is Excel on Windows and no, I do not believe Power Pivot is involved as far as I know. The only Pivot function I use is the regular "Create Pivot Table".