Results 1 to 7 of 7

Max Weekend Value, display date value was seen

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    Windsor, Ontario
    MS-Off Ver
    excel 2010
    Posts
    7

    Max Weekend Value, display date value was seen

    Hey,

    I have 2 columns populated with data
    Column A = Date
    Column B = Value

    I have my sheet already finding and highlighting the weekend days, but I need to find the Max value that is seen only on a weekend.
    I have to do this for every month so the weekend days are at different spots of each month.

    Also when it finds the maximum value I need it to display the date that it occurred on in a cell next to it.

    Any help would be great, I've been looking through forums for the past 2 days with no help.

    Thanks,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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