+ Reply to Thread
Results 1 to 2 of 2

Find MAX values in one column (A) and place data in another column next to the MAX value

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    274

    Find MAX values in one column (A) and place data in another column next to the MAX value

    I have a column (A) of data as such:
    6
    5
    9
    9
    4
    3
    2
    There are of course many more rows. How can I find the MAX value in Column A (in this case 9) and place an 'L' in the corrresponding rows in Column B.
    9 L
    9 L
    Thank you in advance for any guidance/answer.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Find MAX values in one column (A) and place data in another column next to the MAX val

    Maybe something like this...

    Entered in column B and copied down.

    =IF(A2=MAX(A$2:A$10),"L","")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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