+ Reply to Thread
Results 1 to 3 of 3

How to find cell with max value in selected range

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Worthing, UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to find cell with max value in selected range

    Hi,

    Bit of a newbie struggling at the moment. I have columns A to L autofiltered, with the column headings in row 1, so that the values I am filtering by are in rows 2 and on. Now, I have got as far as filtering by column C and then by column D. Now I want to find the cell in column L that has the highest value. I can select the column by visible cells only, but cannot figure out how to move to the cell with the highest value. Would anyone be able to help please?

    Many thanks,

    Igzilla.
    Last edited by Igzilla; 07-20-2011 at 04:30 PM.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: How to find cell with max value in selected range

    Igzilla,

    Welcome to the forum. This is posted in the excel programming section so I'm assuming you're looking for a VBA solution. In your post you stated you're looking at visible cells in column L and you want to select the cell containing the highest value. You can do that with the following:
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar

  3. #3
    Registered User
    Join Date
    07-20-2011
    Location
    Worthing, UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to find cell with max value in selected range

    Thanks tigeravatar - that works perfectly and is a lot simpler than the route I was going down.

    Thanks again!

    Igzilla

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1