+ Reply to Thread
Results 1 to 5 of 5

Finding max value of column in a non-active sheet.

  1. 12-19-2014, 01:57 PM #1
    DogOfAllTrades
    DogOfAllTrades is offline
    Registered User
    Join Date
    12-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Finding max value of column in a non-active sheet.

    I'm trying to find the maximum value in all of the non-empty cells of a single column, column A, of an inactive sheet.

    I've been trying to use this line:
    Please Login or Register  to view this content.
    This seems easy, but I can't think of what to use as the argument for max()

    Any suggestions?
    Last edited by DogOfAllTrades; 12-19-2014 at 02:03 PM.
    Reply With QuoteRegister To Reply
  2. 12-19-2014, 02:06 PM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Finding max value of column in a non-active sheet. 

    Please Login or Register  to view this content.
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 12-19-2014, 02:06 PM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Finding max value of column in a non-active sheet.

    Hi welcome to the forum.

    You may try something like this......
    Please Login or Register  to view this content.
    Does this help?
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 12-19-2014, 02:10 PM #4
    DogOfAllTrades
    DogOfAllTrades is offline
    Registered User
    Join Date
    12-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Finding max value of column in a non-active sheet.

    Thank you both. I could have sworn that I tried that already and received an error, but your code worked perfectly.

    Thanks!
    Reply With QuoteRegister To Reply
  5. 12-19-2014, 02:12 PM #5
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Finding max value of column in a non-active sheet.

    You're welcome. Happy to help.
    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    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. Update table on another sheet with information on ACTIVE SHEET based on column search.
    By keelinglee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 09:06 PM
  2. [SOLVED] Finding current active row and write column A:s value in cell D3
    By a94andwi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2014, 05:00 PM
  3. Finding the last used cell in the active column and paste copied data
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-18-2013, 09:59 AM
  4. [SOLVED] Copy rows from active sheet to another sheet (last row) if condition in column X is met
    By mortless in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2013, 08:11 AM
  5. Search for Value in Closed Workbook and copy Column to Active Sheet Column BE
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-19-2011, 12:57 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1