Can I return text in a pivot table

adsxvii

adsxvii

Board Regular
Joined
Mar 15, 2007
Messages
213
Quick example I have 3 columns. A is Home Team. B is Away Team. C is game number for home team. What I want the pivot table to look like is: the rows would show the home team, the columns would show the game number and the crossing of these 2 would show the away team but I can't seem to return a text value. Any ideas?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You can't do that with a pivot table I'm afraid. You would have to use formulas.
 
Upvote 0
Maybe you could use a query table (not pivot table) with a cross tab result. Use the MAX function. SQL something like (from memory, unchecked)
Code: 
TRANSFORM MAX(away)
SELECT home
FROM source
GROUP BY home
PIVOT `game number`

I'll have a search for some old examples.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
VBA code to extract a table
Replies
5
Views
236
Anthony47
A
V
  • Question Question
Formula to count % of goals in a total number of games
2
Replies
19
Views
368
Peter_SSs
Peter_SSs
C
  • Question Question
Finding Most Recent Date from Specific Date
Replies
2
Views
245
SanjayGMusafir
SanjayGMusafir
G
  • Solved
How to show previous 10 games played
Replies
3
Views
470
bobaol
B
H
  • Solved
Calculation With Numbers Separated By Hyphen
Replies
9
Views
310
honkin
H

Forum statistics

Threads
1,223,911
Messages
6,175,331
Members
452,636
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top