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?
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?
Try
=FLOOR(A1-1,100)+1&"-"&CEILING(A1,100)
Life's a spreadsheet, Excel!
Say thanks, Click *
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks