+ Reply to Thread
Results 1 to 5 of 5

Simple Beginner Question: Return Header from Max Value (More details in body)

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Outer Space, Milky Way
    MS-Off Ver
    Excel 2012
    Posts
    23

    Simple Beginner Question: Return Header from Max Value (More details in body)

    Hello!

    I'm new to Excel and I have been trying to solve this problem for the last hour.

    Columns are months, and rows are the product names. Each cell contains the number of each product sold (x).

    month month month month
    prod1 x x x x
    prod2 x x x x
    prod3 x x x x
    prod4 x x x x

    The "x" vary. By month, I can find the max value with MAX(), but I want to return the product name, not the number sold. So, I want to return the product name that sold the most units for each month.

    Thanks so much ahead of time!

    P.S. Could you recommend a good Excel tutorial? Hopefully a free one...

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Simple Beginner Question: Return Header from Max Value (More details in body)

    maybe you could this out...

    products max.xlsx
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    08-01-2012
    Location
    Outer Space, Milky Way
    MS-Off Ver
    Excel 2012
    Posts
    23

    Re: Simple Beginner Question: Return Header from Max Value (More details in body)

    Thanks! I really appreciate the help. You are very knowledgeable. Could you recommend any sources I could use in learn more in-depth knowledge about excel?

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Simple Beginner Question: Return Header from Max Value (More details in body)

    The best i can think of is here in "Excelforum.com" it's here where i got those things and learned a lot. I was a beginner when i join here that was on Sept. 23, 2011 so it's my birthday next month.

    there are many site's that can teach you but i prefer here co'z you could "talk" to the person giving the solution then you learn and eventually solve your questions.

    cheers.

    thanks for the rep.

  5. #5
    Registered User
    Join Date
    08-01-2012
    Location
    Outer Space, Milky Way
    MS-Off Ver
    Excel 2012
    Posts
    23

    Re: Simple Beginner Question: Return Header from Max Value (More details in body)

    That's good to hear, and I will definitely be seeing you around on this forum. Again, thanks so much for the help!

+ 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