Home » Forums » Open Source Learning Center » Question and Answer

Help with Excel dilemma

Submitted by jecle2001 on 1 August, 2014 - 14:36

My dilemma is simple but hopefully someone can help me. The scenario is such:

I have three columns: A,b,C

(A) has a list of charges received and (B) is the category on each charges and (C) is the insurance that charged (A). now I am trying to get the average of Charges (A) per categories (b) but only selected a few insurances not all the insurances (C) someone please help me. Thank you

‹ How to compare two string in two different workbooks? How to separate an address in a cell with no spaces ›
»
DILIPandey's picture

Hi jecle2001, I believe a

Submitted by DILIPandey on 14 August, 2014 - 07:42.

Hi jecle2001,

I believe a pivot table can help here where you can choose few insurances. Try researching on this and if stuck, upload a sample file. Thanks.

Regards,
DILIPandey

»