![]() I feel like I probably need some sort of IF formula, but I'm not sure how to apply that in this instance, and how those work with pivot tables. ![]() I can obviously do a pivot table to group and count instances of a certain name, but I'm stuck on what the next step would be to be able to look at the other data associated with that name. ![]() I suspect there is a space, or non-printing character, (or formula) in that cell. Hiding the blanks at the pivot table is not working either. The trouble I'm having is that the customer data is in different fields, so that it's like A34=John B34=L. My column data has dates and blanks, and I would like to get rid of the blanks so my pivot table will group by years (thats my though I dont know if thats what happen). What I'd ultimately like to do is pull all these "same customer" transactions out and compare the difference in the amount purchased on the different dates, so that one could generate stats like, "on second visit the amount purchased declined by an average of X%" For the sake of example, let's say it's customers who have bought items on different dates. I use excel 2007 at work and excel 2003 for Mac at home.īasically, what I would like to do is to examine a subset of this data. I'm trying to answer some questions using a large data set of transactions (it had to be broken up in order to avoid exceeding the row limit for Excel).
0 Comments
Leave a Reply. |