Join 3,556 readers in helping fund MetaFilter (Hide)

13 posts tagged with pivot. (View popular tags)
Displaying 1 through 13 of 13. Subscribe:

Related tags:
+ (11)
+ (5)
+ (4)


Time to get a new job pt. 2

I know exactly what I want out of work, and it is this: working on creative projects to make something useful (and also cool) as part of a team. And also money. Not tons, but enough to get by. I have a BA, but nearly all my work experience to date has been in low/no-skill labor. How do I bootstrap myself into a new career and what should I even be looking at? [more inside]
posted by zchyrs on Jul 30, 2014 - 6 answers

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]
posted by Frowner on Jun 20, 2012 - 6 answers

How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]
posted by teg on Dec 6, 2010 - 14 answers

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]
posted by Jimbob on Nov 23, 2010 - 12 answers

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]
posted by DZ-015 on Sep 4, 2009 - 1 answer

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]
posted by amarynth on May 8, 2009 - 5 answers

Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]
posted by SirStan on Mar 25, 2009 - 3 answers

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]
posted by ttyn on Jan 6, 2009 - 5 answers

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]
posted by niles on Oct 20, 2008 - 7 answers

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]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

Please Help Me Create Stick Figure Servants To Do My Bidding

I'm lusting after Pivot Stickfigure Animator 2.2. The problem is, I have a Mac and it's for Windows. [more inside]
posted by misha on Feb 11, 2008 - 10 answers

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]
posted by bwilms on Jun 9, 2006 - 10 answers

Pivot Table Charting Help

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]
posted by dantodd on Mar 30, 2006 - 4 answers

Page: 1