+ Reply to Thread
Results 1 to 2 of 2

Grouping the same values by a number sequence for a column

  1. #1
    Registered User
    Join Date
    04-09-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2003
    Posts
    21

    Grouping the same values by a number sequence for a column

    I am trying to group the same values in columns together and i was thinking about having a number count. What's the function that might be able to display this (display whats in Column B in the example below)?

    Values
    5000 1
    5000 1
    6000 2
    7000 3
    7000 3
    8000 4
    8000 4
    8000 4
    9000 8
    10000 9
    10000 9

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Grouping the same values by a number sequence for a column

    Supposing values are in col A and B, enter 1 in B1 and in B2
    Please Login or Register  to view this content.
    and pull down as needed

+ 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