98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel query
Excel query
Resolved · High Priority · Version 2007
Mon 11 Jun 2012, 12:10Delegate Cathryn said...
Cathryn has attended:
Excel Intermediate course
Excel Intermediate course
Excel query
I have an excel file that I need some help in manipulating the data
Mon 11 Jun 2012, 12:13Trainer Anthony said...
RE: Excel query
Hi Cathryn, thanks for your query. What's the nature of the problem?
Anthony
Mon 11 Jun 2012, 12:18Delegate Cathryn said...
RE: Excel query
I think its a pivot table query - I need to obtain total transaction count by city ie i have a hotel name, city, transaction amount and I need to collate all spend in one city by hotel name.
Mon 11 Jun 2012, 12:36Trainer Anthony said...
RE: Excel query
Yes, that definitely sounds like a Pivot Table task to me. If you haven't messed with Pivots before have a look here for a good walkthrough. If you going to count transactions, you might need to change the default analysis on the Pivot Table from Sum to Count:
http://www.bettersolutions.com/excel/EUA153/VL115526332.htm
Anthony
Mon 18 Jun 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Validating text entries1. Select the range of cells. where A1 is the first cell in the range. 6. Click OK. |
