Results 1 to 8 of 8

Max value in table IF variable condition met

Threaded View

FrankHouston Max value in table IF... 07-16-2012, 11:36 PM
vlady Re: Max value in table IF... 07-16-2012, 11:44 PM
FrankHouston Re: Max value in table IF... 07-17-2012, 09:19 AM
MarvinP Re: Max value in table IF... 07-16-2012, 11:45 PM
FrankHouston Re: Max value in table IF... 07-17-2012, 09:23 AM
vlady Re: Max value in table IF... 07-17-2012, 09:06 PM
FrankHouston Re: Max value in table IF... 07-17-2012, 10:11 PM
MarvinP Re: Max value in table IF... 07-17-2012, 09:42 PM
  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    Houston
    MS-Off Ver
    Excel 2007
    Posts
    4

    Max value in table IF variable condition met

    I’ve got a table (example s/s attached), with:

    Date in column A (table won’t necessarily be sorted by date, but could be if needed)
    Person Name in column B
    Sales in column C
    I want to identify the largest Sales for each date (column D), so I can calculate each person's daily % of the largest daily sales (column E).

    I’ve searched the web, and tried a wide range of functions, including array functions, but can’t find something that seems to work for my situation. It seems this has to be something others have encountered and solved - it’s not that unique.

    Any suggestions would be greatly appreciated.
    - Frank
    Attached Files Attached Files

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