PaulFogel123
Member
I have what must be a common problem. The attached file has a sample Pivot Table. In that file, 182 refers to the company number, and there are a lot of companies (only two are used here). I am using a Pivot Table like this as a database from which to extract data to populate models for each company. I need to extract the amounts by company number, but the amount and company number are on separate rows. So, for example, I need to find Bad Debt Expense (row 6) for company 182 (row 8). I have tried SUMPRODUCT and GETPIVOTDATA functions, but I think they want proper database format (expense and company number in the same row).
Any solutions?
Paul
Any solutions?
Paul