+ Reply to Thread
Results 1 to 3 of 3

Column value 1-100 and repetitive

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Column value 1-100 and repetitive

    I have 2 million data points.. I want to classify them as 1-100 in a sequential order and repeat the same from 101-200 as 1-100 all in one column. How do i do that?

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Column value 1-100 and repetitive

    Try

    =FLOOR(A1-1,100)+1&"-"&CEILING(A1,100)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    04-30-2014
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Column value 1-100 and repetitive

    I couldn't achieve it using the above forumula. I need something like this.. 1 2 3 ....25690000 data sets are there ... 1.2.3.4.5...100 and 101 should become 1 .. 150 .. 50... 250...50 ..300...100.. 400..100 501..1..601...1 and it needs to repeat till i get the last value.

+ 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. Macro to transpose repetitive 24 entries from column to rows
    By balaji2285 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-06-2013, 07:48 AM
  2. Adding a repetitive word in all rows of a column
    By zeudoc77 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 03-09-2012, 12:42 PM
  3. repetitive changes in a link
    By DeniseLinscom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2009, 03:42 PM
  4. Repetitive VBA code
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2007, 03:10 PM
  5. repetitive
    By Repetitive formula in forum Excel General
    Replies: 2
    Last Post: 06-28-2006, 01:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1