Results 1 to 42 of 42

Find lowest and the highest values across the sheets and enter into cell

Threaded View

  1. #11
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Find lowest and the highest values across the sheets and enter into cell

    No Worksheet Activate event anymore.

    1) Double click on Col.A will update all data.
    2) Add/change in Col.A will update corresponding 2 cells.
    3) change in Col.B is taken as new MIN and updates other same name accordingly if any.
    4) change in Col.C is taken as new Max and updates other same name accordingly if any.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-15-2020, 02:18 PM
  2. Find Sequential Highest High, Lowest Low values
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-23-2015, 01:18 AM
  3. Replies: 1
    Last Post: 01-10-2014, 01:55 PM
  4. Replies: 4
    Last Post: 01-07-2014, 03:38 AM
  5. [SOLVED] Formula to find lowest/highest value in a column and return value to that cell
    By maryren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2013, 11:21 AM
  6. Find highest and lowest values for a range of dates
    By kersties in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2013, 05:55 AM
  7. Continuous changing cell values - record highest and lowest values in seperate cells
    By attienel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2013, 05:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1