+ Reply to Thread
Results 1 to 6 of 6

macro to select and rank top 10 column B values for Column A values

  1. 03-28-2018, 05:27 AM #1
    genetist
    genetist is offline
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    macro to select and rank top 10 column B values for Column A values

    Hi to all
    Good Afternoon

    I have three columns of data genotype1 (Coumn A), genotype2(column B) and values (column C), Now I want to get top 10 genotype2 values i.e. column2 records based on column C values and rank them for column A values. now I am using filter function in excel and I got some macro in my internet but they are giving only top. Here I am posting my posting my example dataset for better understanding.

    https://www.dropbox.com/s/z9oohrn6ij...heet.xlsx?dl=0

    Any help in this regard is highly appreciable
    Thanks in Advance
    regards,
    Reply With QuoteRegister To Reply
  2. 03-28-2018, 08:25 AM #2
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: macro to select and rank top 10 column B values for Column A values

    Instead of dropbox, please attach workbook to thread. thanks
    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary. Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear
    Reply With QuoteRegister To Reply
  3. 03-28-2018, 11:34 AM #3
    genetist
    genetist is offline
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    Re: macro to select and rank top 10 column B values for Column A values

    please find example file here
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-29-2018, 10:47 AM #4
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: macro to select and rank top 10 column B values for Column A values

    Thanks for the file - will look at this over the weekend
    Reply With QuoteRegister To Reply
  5. 03-30-2018, 03:31 AM #5
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: macro to select and rank top 10 column B values for Column A values

    One method
    - the data is sorted by value within GenoType1
    - the first 10 values for each category are retained

    Output matches what you said you wanted in sheet "After"

    Run from sheet "Before" with shortcut {CTRL}K


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kev_; 03-30-2018 at 03:34 AM.
    Reply With QuoteRegister To Reply
  6. 03-30-2018, 06:38 AM #6
    genetist
    genetist is offline
    Forum Contributor
    Join Date
    04-09-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    176

    Re: macro to select and rank top 10 column B values for Column A values

    Dear Kev_
    Thanks lot for your help and your code is working like charm and perfect
    Thanks lot once again
    regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Rank values in one column from groups of numbers in another column
    By fruit&veg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2014, 03:48 PM
  2. [SOLVED] Rank values in one column from groups of numbers in another column
    By fruit&veg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2014, 01:04 PM
  3. Macro to rank values of a particular column when Acc No. is entered to identify Top 10
    By mdlpjr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2013, 07:59 PM
  4. Macro to select the column values without using header
    By shanmp77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2010, 06:40 AM
  5. Edit Macro to select all values in a column one by one and then print
    By Hollis27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2009, 01:59 PM
  6. Edit Macro to select all values in a column one by one and then print
    By Hollis27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2009, 01:56 PM
  7. Edit Macro to select all values in a column one by one and then print
    By Hollis27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2009, 01:52 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1