Results 1 to 5 of 5

Excel tables - mulitple columns headers with same month/year adding a "2"

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2016
    Location
    Salisbury, NC
    MS-Off Ver
    Office 2010
    Posts
    2

    Excel tables - mulitple columns headers with same month/year adding a "2"

    Hi, I run many reports that look like the attached. I will have a location, then two or three criteria for the same months of the year; however, the second time the months are listed, excel automatically adds a "2" to end of the date since it thinks it's a duplicate. How can I keep the dates the same?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting error trying to "group" by Day, Month and Year on a pivot table
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-03-2015, 05:14 PM
  2. Replies: 1
    Last Post: 03-23-2015, 06:19 PM
  3. [SOLVED] Excel 2007: How to Convert "5/2/2013" to "May" then subtract a Month so it's "Apr"
    By Golom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 02:00 AM
  4. Replies: 12
    Last Post: 06-10-2013, 05:42 PM
  5. Date/Month/Year formatting for column "c" not working for me...
    By Rabbitstew in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-02-2013, 10:37 PM
  6. [SOLVED] making a "if" function that uses only the month/year values from a date
    By ATraveller in forum Excel General
    Replies: 6
    Last Post: 10-02-2012, 03:43 AM
  7. Working out age from "Day" "Month" "Year"
    By timmyc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2006, 11:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1