Forum Discussion

rutvik276's avatar
rutvik276
Copper Contributor
Mar 18, 2020
Solved

help please

hey can anyone help me solve this .it URGENT.there is a big table of medical cost analysis(includin BMI,AGE GROUP,REGION,CHARGES,SMOKER-YES/NO) and i have to find out about all this   1. Here...
excel
  • ExcelExciting's avatar
    ExcelExciting
    Mar 23, 2020

    Hi rutvik276 

     

    Please see the attached file with all your question solution

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

ExcelExciting's avatar
ExcelExciting
MVP
Mar 18, 2020

Hi rutvik276 

 

The best solution is to make the PivotTable that can answer all your point.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

  • rutvik276's avatar
    rutvik276
    Copper Contributor
    Mar 18, 2020

    i make a pivot table then how to do sir.i am a beginner in excel.i know to add different categories but how will that answer my questionsExcelExciting 

    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Mar 18, 2020

      Hi rutvik276 

       

      Share the sample data with your records

       

      Regards, Faraz Shaikh 

      • rutvik276's avatar
        rutvik276
        Copper Contributor
        Mar 18, 2020

        i am sorry but i dont know how to send excel file hereExcelExciting 

Resources