Results 1 to 6 of 6

Automatic sorting names based on numerical data

Threaded View

Littlesimon Automatic sorting names based... 01-08-2015, 10:03 PM
ashishmehra2010 Re: Automatic sorting names... 01-09-2015, 01:53 AM
Littlesimon Re: Automatic sorting names... 01-09-2015, 02:49 AM
ashishmehra2010 Re: Automatic sorting names... 01-09-2015, 06:02 AM
samba_ravi Re: Automatic sorting names... 01-09-2015, 06:32 AM
Littlesimon Re: Automatic sorting names... 01-15-2015, 05:45 PM
  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Australia
    MS-Off Ver
    Mac 2011
    Posts
    75

    Question Automatic sorting names based on numerical data

    Hi,

    I am trying to create an assessment spreadsheet. Next to a name, a mark is given in a number format. Depending on what mark is given, it will then place the name under the corresponding mark heading in alphabetical order. I'd like this to happen in the same sheet and also in another sheet. I have the currently used the following formula =IF(G6=8.5,A6,0). This has done what I would like but there are 0's in between the names. I'd like no zero's and no spaces between names. I have attached my document, 'Test' is what I tried to do and 'What i would like' is how I'd like it to appear. I know how to use formulas but I think this may require more technical advice. Any advice would be greatly appreciated. Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] automatic replace sheet names based on new cell text (within defined range)
    By Robert1311 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2014, 05:37 AM
  2. [SOLVED] Sorting numerical data in a pivot table
    By katieshields in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-25-2013, 04:20 AM
  3. Sorting Numerical data..
    By Hodged in forum Excel General
    Replies: 4
    Last Post: 11-06-2006, 06:18 AM
  4. Replies: 3
    Last Post: 01-17-2006, 10:10 AM
  5. [SOLVED] Having trouble sorting numerical data from SQL analysis cube
    By Andy S. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2006, 10:10 AM

Tags for this Thread

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