+ Reply to Thread
Results 1 to 4 of 4

finding and displaying a specific max value in a table

  1. #1
    Forum Contributor
    Join Date
    08-03-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    120

    finding and displaying a specific max value in a table

    Hi,
    i have got the following problem. Cell N5 has a value of 5000 which gives me a row number 5000. I want to find the maximum value of row 5000 to row 5048, and display this max value in G5000 to G5048 as I want to draw this as a horizontal line in a time series chart (48 units).

    thanks

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: finding and displaying a specific max value in a table

    Can you use the MAX formula? =max(a5000:a5048)
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    08-03-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    120

    Re: finding and displaying a specific max value in a table

    yes i can use that formula but i need the formula to be displayed 48 times as i want to display it as horizontal line in a graph

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: finding and displaying a specific max value in a table

    you can put the same formula in the cells

    or do range("a5000:a5048").value=application.worksheetfunction.max(range("a5000:a5048")

+ Reply to Thread

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: 01-15-2013, 11:26 AM
  2. Replies: 1
    Last Post: 09-05-2012, 09:38 AM
  3. Replies: 20
    Last Post: 05-15-2012, 04:42 AM
  4. finding specific data from one table and pasting it into another table
    By saranorton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2011, 09:35 AM
  5. Replies: 3
    Last Post: 09-09-2011, 08:24 AM

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