Results 1 to 3 of 3

Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style

Threaded View

steverokh Filter / Report Top 10 Values... 03-04-2013, 01:28 AM
Leith Ross Re: Filter / Report Top 10... 03-04-2013, 02:51 AM
steverokh Re: Filter / Report Top 10... 03-04-2013, 05:10 AM
  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    10

    Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style

    Hi Everyone,

    I have a load of Census data in an excel format. It has ancestry values for each postcode (2000+) and I want to get the TOP 10 Values from each (with their identifier) - so for instance;

    Postcode 2000 - Top 10 would be 1. 4000 (chinese) 2. 2131 (indian) 3. 2000 (Vietnamese) ETC ETC ETC and so forth.

    Would this be possible? I Know it's not an easy task and sounds like a big job, But having to manually do this is.. well.. a much bigger job.

    In essence it would look like postcode + Cell identifer + cell value for each postcode. I have attached the test data.

    Regards,

    Steve
    Attached Files Attached Files

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