+ Reply to Thread
Results 1 to 10 of 10

Pivot Table auto serial numbers

  1. 05-20-2020, 08:08 AM #1
    siddiq1212
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    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
    Reply With QuoteRegister To Reply
  2. 05-20-2020, 01:32 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table auto serial numbers

    Pivot Table sorted on column M.

    See the attached file.
    Attached Files Attached Files
    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.
    Reply With QuoteRegister To Reply
  3. 05-20-2020, 03:15 PM #3
    siddiq1212
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    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.
    Reply With QuoteRegister To Reply
  4. 05-20-2020, 03:26 PM #4
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table auto serial numbers

    Please show it manualy added in the excel file.
    Reply With QuoteRegister To Reply
  5. 05-22-2020, 10:31 AM #5
    siddiq1212
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    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.
    Reply With QuoteRegister To Reply
  6. 05-22-2020, 12:43 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table auto serial numbers

    See the expected result in Column L.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 05-22-2020, 03:22 PM #7
    siddiq1212
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    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?
    Reply With QuoteRegister To Reply
  8. 05-23-2020, 11:14 AM #8
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    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.
    Reply With QuoteRegister To Reply
  9. 05-24-2020, 12:32 PM #9
    siddiq1212
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    Re: Pivot Table auto serial numbers

    Please refer attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 05-24-2020, 12:48 PM #10
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Serial Number in Pivot Table
    By mubashir aziz in forum Excel General
    Replies: 12
    Last Post: 11-02-2022, 08:56 AM
  2. VBA to create dynamic table/pivot table to auto refresh charts on other sheets
    By jamesbutler2021 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2019, 09:27 AM
  3. How to add serial numbers in pivot table.
    By Ejaz Qureshi in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-28-2014, 12:14 AM
  4. Auto serial numbers across multiple work sheet in a workbook in a particular cell
    By subhassamuel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2013, 05:43 AM
  5. Purchase form with auto-sequential serial numbers
    By psanghvi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2012, 05:40 PM
  6. import data from access table to excel pivot table - Enable Auto Refresh
    By okl in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-01-2010, 09:38 AM
  7. Finding a serial number in a list of serial numbers
    By zocoloco in forum Excel General
    Replies: 2
    Last Post: 02-04-2009, 05:20 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1