+ Reply to Thread
Results 1 to 6 of 6

Finding the highest value in a column and changing the group

  1. 04-08-2010, 05:20 PM #1
    abuchan
    abuchan is offline
    Forum Contributor
    Join Date
    11-09-2008
    Location
    Washington State
    MS-Off Ver
    2007
    Posts
    164

    Finding the highest value in a column and changing the group

    Attached is a sample file which is part of a bigger project which is slowly coming together. Sheet1 includes three columns (A) 'parcelnumber', (B) 'improv_id', and (C) 'bld_num'. I need to create a fourth column which shows how many (total) buildings are associated with a specific parcel number. On Sheet 2, I have hand-created what I am trying to obtain. In essence, I am hoping to show that an improvement is 3 of 4 or 1 of 1 or 7 of 15 and so on. The 'real' file has approximately 40,000 entries so it is a little more than is realistic. Also, as this is part of a bigger project, I am hoping to complete this task as a macro.

    Thank you for any insight you can provide.
    Attached Files Attached Files
    Last edited by abuchan; 04-09-2010 at 09:29 AM.
    Reply With QuoteRegister To Reply
  2. 04-08-2010, 06:13 PM #2
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Finding the highest value in a column and changing the group

    Hi

    I think this formula will give you the result you want.

    Please Login or Register  to view this content.
    If so, then have a macro put it into the first output cell, then have it copied down. You could then convert to a value if required.

    rylo
    Reply With QuoteRegister To Reply
  3. 04-08-2010, 06:16 PM #3
    abuchan
    abuchan is offline
    Forum Contributor
    Join Date
    11-09-2008
    Location
    Washington State
    MS-Off Ver
    2007
    Posts
    164

    Re: Finding the highest value in a column and changing the group

    Thank you but please excuse my ignorance, I have no idea of what to do with it. Everything I know about Excel I have learned through this site, but my confidence level does not yet include taking a statement like this and making a macro out of it...
    Reply With QuoteRegister To Reply
  4. 04-08-2010, 07:59 PM #4
    abuchan
    abuchan is offline
    Forum Contributor
    Join Date
    11-09-2008
    Location
    Washington State
    MS-Off Ver
    2007
    Posts
    164

    Re: Finding the highest value in a column and changing the group

    As I don't understand the solution provided, I am attaching my attempt hoping for a little direction. My attempt copies the data from the previous page but I still can't get column D to produce. 
    Please Login or Register  to view this content.
    This is based on the active sheet being sorted with Column C from most to least.

    Thank you.
    Reply With QuoteRegister To Reply
  5. 04-08-2010, 11:12 PM #5
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Finding the highest value in a column and changing the group

    Hello Alec,

    I time tested this macro by copying the 157 rows of your test data to make over 40000 rows. On my computer this took only about 1 second to complete. This has been added to the attached workbook.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  6. 04-09-2010, 09:27 AM #6
    abuchan
    abuchan is offline
    Forum Contributor
    Join Date
    11-09-2008
    Location
    Washington State
    MS-Off Ver
    2007
    Posts
    164

    Re: Finding the highest value in a column and changing the group

    Works like a charm. Must be on Sheet 1, but it probably says that in Galic somewhere
    Thank you.
    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)

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