Results 1 to 5 of 5

looking up maximum valus in a cell range

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-10-2011
    Location
    swindon, england
    MS-Off Ver
    Excel 2010
    Posts
    317

    looking up maximum valus in a cell range

    Hi

    I two tables in excel. One table has 10 columns with the headings
    Dates, HUK, HBUK, IMG, Bentley, MAN, BMW, HBE, HNL

    The second table is below. The numbers in the second table below are the max of each of the object columns above

    HUK 5
    HBUK 7
    IMG 2
    BGBL 8
    MAN 9
    BMW 10
    HBE 7
    HNL 9

    However i need to add a column to the second table which displays the dates listsed in the first table. However the dates need to be for the max numbers below. For example if the huk max is 5 then the date on the corresponding row is 12/04/2011 e.g.

    Does anyone know how to do this?

    Thanks

    Jeskit
    Last edited by jeskit; 07-01-2011 at 07:18 AM.

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