Excel Forum
Similar Content
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situati...
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...



Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Text


See how to create a Year Category for a Pivot Table from Dates Entered as Text using the RIGHT function and the Ampersand & (Join Symbol). Then we can calculate Year Over Year Sales showing Percentage Change using the Show Values As % Of Value Field Setting.





Got a Question? Ask it Here in the Forum.