Results 1 to 19 of 19

Help with a sheet dividing information withing a column of cells?

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2014
    Location
    NYC
    MS-Off Ver
    2013
    Posts
    11

    Help with a sheet dividing information withing a column of cells?

    So hello to all forum members, and I want to point out that while it is pretty lame of me to ask assistance of members immediately after registering for the forum, I must say in my defense that I have a time limit on a dead line and it would be insanely helpful if you could just assist me for my class in data base statistic. Every opinion will be appreciate it and I promise to provide with what little I may know on excel or related knowledge. It's for a statistic assignment and its not like I don't wanna do the work, it's just darn hard as hell, I mean this is kind of working on it since I'm posting just about everywhere for help lol.


    So here it goes:
    I have a sheet with a column of about 1,200 cells with series of numbers like this, five in total:
    01 04 12 35 45
    01 02 09 75 46
    02 08 12 45 55
    08 45 12 32 48
    16 65 12 32 87

    I need to do a couple things with this long list.
    1. Is there any way to divide each pair of numbers so that each pair occupies a column of its own, giving thus each pair a column each? What I want to do then is, re-order each column in ascending order to know how many of each exact pair of numbers there are, for example:
    01 08 16
    01 08 16
    01 08
    01 08
    01
    So then I could clearly count six "01"'s, four "08"'s and three "16"'s that originally where in the first pairs out of the six total, originally. So now, I would only have to move on the next pair of that initially 'six' pair. So if I had twelve thousand cells in a column of six-paired numbers(eg 03 12 34 54 66) now I have five that I would need to give a column to each to know how many of each pair of numbers there were in the second series of these..(so if i had 03 12 34 54 66, and I successfully took out the first in each cell, I would now respectively have 12 34 54 66, meaning from the second and on on each cell.) Please see attached form.Book2.xlsx

    2. The last piece of the puzzle would be to perform, if at any way or fashion possible, a sorting in order of each individual pair of number in their new column by the date they were populated on that database.
    So again:
    If,
    01 04 12 35 45 3/1/14
    01 02 09 75 46 3/2/14
    02 08 12 45 55 3/3/14
    08 45 12 32 48 3/4/14
    16 65 12 32 87 3/4/14

    then I want to try and divide yes, each of those numbers, into separate columns, which I will later copy paste unto a new sheet, but now, eureka, now they have dates! Hehe, So now, I could perform my other menial tasks on each sheet more closely and clearly as I would have something like:
    01 3/1/14 04 3/1/14 12 3/1/14
    01 3/2/14 02 3/2/14 09 3/2/14
    02 3/3/14... 08 3/3/14... 12 3/3/14...

    And so forth. My ideal goal would be to not only be able to divide the 1st,2nd,3rd,4th,5th pairs into a column each, but if at all possible, to do so accompanied by their populated date in a cell next to them that also allows me sort the numbers in ascending order, while keeping that original date next to them.

    Thank you guys, I'll owe you so much!
    Last edited by LoyalLegend; 11-02-2014 at 11:20 AM. Reason: grammar etc

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying sheet information the column of cells
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-04-2013, 04:46 PM
  2. Replies: 12
    Last Post: 05-03-2013, 07:18 AM
  3. Replies: 3
    Last Post: 07-17-2012, 05:03 AM
  4. Excel 2007 : Dividing information on multiple sheets
    By mabs239 in forum Excel General
    Replies: 4
    Last Post: 05-31-2010, 05:35 AM
  5. Increase column heading letters withing routine?
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2006, 10:35 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