Results 1 to 12 of 12

can't pull greatest date using criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2008
    Location
    Columbus OH
    Posts
    7

    can't pull greatest date using criteria

    working in a workbook and need to summarize on the first page. Each workbook page has the same format, Colume A is the team name, B-J are columes of data and colume K is the completion date. The teams are listed more then 1x each, and I need to pull the greatest date in colume K associated with each team, but only need the team name listed and the greatest date showing in the summary page. I thought I had it with this formula, only to see that it's pulling the greatest date in the range, not the greatest date associated with the team.
    =MAX(IF(Queries!A18:A153,"Financial Services",Queries!K18:K153))
    Last edited by wendyhatwork; 10-21-2008 at 02:59 PM. Reason: was told to change title

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