Results 1 to 6 of 6

return MAX based on criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    17

    return MAX based on criteria

    hi i have a spreadsheet like the following

    A B C
    Country Revenue Month
    1 UK 10 Jan
    2 France 20 Jan
    3 US 30 Jan
    4 UK 25 Feb
    5 US 35 Feb
    6 France 5 Jan

    and so on...

    So where country = UK, France or US I want to retrieve the MAX revenue from all months and which month it was in.

    Eg UK max revenue was in Feb of 25.

    I am not sure how to apply the max formula with criteria. Is there any way to do this?

    Thanks in advance!
    Last edited by oldchippy; 11-09-2008 at 12:14 PM.

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