+ Reply to Thread
Results 1 to 5 of 5

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

  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

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

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

    You cannot have a TABLE or a PIVOT TABLE with column headers with the EXACT same name.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

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

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

    Thanks. I've been changing them manually, but didn't know if there was a way to bypass the duplicate issue. For my reports, that is the way it needs to be laid out.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

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

    You can add a SPACE after the second one, so it will APPEAR the same BUT be different.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

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

    you can use a regular range instead of a table or use a table without a header row if you don't need structured references
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

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