Results 1 to 29 of 29

How do I use Excel to random sort?

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    46

    How do I use Excel to random sort?

    Hi everyone,

    I'm new to the forums! I have a copy of a post that was made to my thread on another forum, but I don't understand any of it. It's like what is he talking about? It's like he went advanced on me that I wasn't expected such a reply. It's like I read it over a million times. I mean I never ever used Excel in my life before. I don't even know where to get it from and I honestly don't know if its free.

    Alright, here's the reply.

    1. Using an Excel spreadsheet, write the complete title for every CD in alphabetical order by row in Column A.
    2. In the adjacent Column B, write the total number of letters in the title of the CD from Column A.
    3. In Column C, write a formula to calculate the cube root of the number in Column B to the 13th decimal place (or you may use any Fibonacci number of your choice).
    4. Custom sort the value returned in Column C in ascending order.


    1.) I understand the part by writing in alphabetical order, but what is row by Column A?

    2.) OK, that means count every single letter and enter the number into Column B?

    3.) I suck at Math, I don't know how to figure that out and I don't know how to write a formula, and what are Fibonacci numbers? Could someone please throw in a few numbers to make a choice? That would be easier than writing cube formulas.

    4.) What does custom sort the order in ascending order means? Ascending means in order from A to Z, right? Won't the result come back the same as in#1 when I wrote them in alphabetical?
    Last edited by FDibbins; 02-19-2014 at 06:13 PM.

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