##
12 posts tagged with excel *and* pivot.

Displaying 1 through 12 of 12. Subscribe:

## Pivot table help for n00b

I need to provide some sales data but am unsure how to manipulate the data in a pivot table to get the specific details requested. I'm sure this is simple but my pivot table skills are, admittedly, terrible. Details inside. [more inside]

## Help me pivot the pivot table back!

How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed. [more inside]

## How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]

## Microsoft Acess Charts dead-end.

Microsoft Access 2007 - how on earth do I cut / copy / export / do

*anything*with my Pivot Chart, besides print it? [more inside]## Differences between Excel Pivot Tables

Why is the functionality of an Excel Pivot table different depending on whether you use a list or a multiple consolidation range? [more inside]

## This might be someone's homework, but it's not my homework

I'm trying to teach myself to be an Excel guru, and I'm having trouble with pivot tables. I'm using data from exercises in a textbook (which is about how information systems are used in business but randomly has a bunch of Excel exercises in the back). I can come up with a solution, but I don't know if I'm doing it the most efficient (or most elegant) way. [more inside]

## Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]

## Help me figure out how to go about making Excel magic

How can I have Excel generate a new column with the data I need using certain conditions and pulling data from a pivot table? [more inside]

## Can I make an Excel chart from only one column?

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]

## Stumped by VBA-ising an array formula in Excel

How to do a VBA version of the following array formula in Excel?
The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA:
{="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)}
[more inside]

## Excel - Concatenate fields through Vlookup...or something

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]

## Pivot Table Charting Help

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]

Page:
1