Excel query

Save Share

This query is : Resolved

Quick Summary

This discussion explains how to summarise data in an Excel sheet, specifically demonstrating how to use a Pivot Table. It addresses a user's question about placing text within the values field of a Pivot Table. For further assistance and learning, users are directed to the Excel forums at excelforum.com and mrexcel.com.

Guest

Guest (Querist)

25 May 2020 How to summarize the data given in Excel sheet below? I have also shown the manner in which data is required.

https://docs.google.com/spreadsheets/d/1T64Zc-QFPqhzPwpgZxIcje7Qzyb9vtf7h4ibaIDU65A/edit?usp=drivesdk

CA ANKIT GADA

CA ANKIT GADA (Expert)
Follow

26 May 2020 Use Pivot Table function

Guest

Guest (Querist)

28 May 2020 Sir please guide me on how to place text in values field of pivot table?

Aashok Kumar Sharma online

Aashok Kumar Sharma

(Expert)
Follow

04 June 2020 You can learn a lot of Microsoft Excel. Please register and post you query in the below forums

https://www.excelforum.com/
https://www.mrexcel.com/

Guest

Guest (Querist)

04 June 2020 Thank you so much. This forums are very useful.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now