Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #16  
Old 07-11-2017, 06:49 AM
hollies hollies is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jun 2017
Location: Nottinghamshire
Posts: 22
hollies is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
As far as I know, you can't get pivot tables to display like like that. You could filter the table but that's a pain in the arse.

Access can do it, fer sure. So long as you don't need to collaborate with anyone, then that would be the easiest way. Overkill, as Arvi said earlier.
Many thanks everyone for your help with this, I really appreciate it. I have learnt so much on both Excel and Access.

Just need to work out for myself the best way of doing things.

Thanks again.

Rob
Reply With Quote
  #17  
Old 07-11-2017, 08:09 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 788
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

If you want to avoid Access I would propose that you post a Excel sheet with a reasonable quantity of data and (manually entered) examples of expected results.

Maybe it is not possible in Excel but let it depend on trial.
Reply With Quote
  #18  
Old 07-18-2017, 03:21 AM
hollies hollies is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jun 2017
Location: Nottinghamshire
Posts: 22
hollies is on a distinguished road
Default

I have now been playing with pivot table for a week and have virtually got it exactly how i want it.

If only I had learned about PT's years ago!!

One thing I am unable to do is to have a value field in between 2 Row fields.

ie my columns are

Venue - Capacity - Next Date - Note - and Max of Date 4 x Row Field and 1 Value Field

The Max of date obviously returns the last date played at a particular gig.

However, I want this column to be after the Capacity Column and the Next Date and Note to be at the end of the row like this

Venue - Capacity - Max of Date - Next Date - Note 2

That is 2 x Row Field - 1 Value Field - 2 x Row Field

Can this be achieved.

Many thanks Rob
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel or Access for DB? John H. Power Word 3 08-03-2016 11:52 AM
Excel to Access to Excel for report automation Nicholaspoe Excel Programming 10 10-08-2013 08:13 PM
Access or Excel? hektisk Office 11 04-11-2011 04:24 PM
Should I uses Access or Excel? tinkertron Office 5 03-29-2009 08:30 PM
Excel or Access ? inferno Excel 1 12-06-2008 08:43 AM


All times are GMT -7. The time now is 06:50 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft