+ Reply to Thread
Results 1 to 10 of 10

Pivot Table auto serial numbers

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    69

    Post Pivot Table auto serial numbers

    Greetings Experts,
    I know this may be asked before but am not able to search it.
    In the attached file in column L i need to see serial nos as per data i.e 1,2,3,.,.....etc.
    Please help in this regards.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,844

    Re: Pivot Table auto serial numbers

    Pivot Table sorted on column M.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Pivot Table auto serial numbers

    I think you get it wrong.
    I need to see serial nos. 1,2,3,4,5,6 in column l as i will enter data in data sheet.
    1st Row - 1
    2nd Row - 2
    3rd Row - 3
    4th Row - 4
    etc.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,844

    Re: Pivot Table auto serial numbers

    Please show it manualy added in the excel file.

  5. #5
    Registered User
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    69

    Question Re: Pivot Table auto serial numbers

    Please refer attached.
    Attached Files Attached Files
    Last edited by siddiq1212; 05-22-2020 at 10:49 AM.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,844

    Re: Pivot Table auto serial numbers

    See the expected result in Column L.

  7. #7
    Registered User
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Pivot Table auto serial numbers

    Thanks for replying,It's working for two columns only.
    Is there any work around for multiple columns for data table?

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,844

    Re: Pivot Table auto serial numbers

    Please show in your excel file what you like to achieve.

    I did not read this question earlier in your comment.

  9. #9
    Registered User
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Pivot Table auto serial numbers

    Please refer attached.
    Attached Files Attached Files

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,844

    Re: Pivot Table auto serial numbers

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Please explain the relationship between B V A and 504

    And C W 609

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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