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
RE: Excel query
Hi Cathryn, thanks for your query. What's the nature of the problem?
Anthony
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.
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