Results 1 to 5 of 5

Finding the last entry in a row with a second criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    3

    Finding the last entry in a row with a second criteria

    Hello,

    I currently have a formula which finds the last date that has been entered in a row by using OFFSET, MATCH and MAX.

    I would like to be add a second criteria that shows the last entry in a row that is below a certain date. In the spreadsheet that is attached, I have data in the April columns for example 4, but would only like to show the latest entry made before the end of March.

    Any help would by greatly appreciated.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding Double entry
    By chandan12 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 12:08 PM
  2. Finding and summing an entry once
    By Qualo_Jinn in forum Excel General
    Replies: 9
    Last Post: 04-30-2012, 09:49 AM
  3. finding an entry from two criteria.
    By garyablett in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2006, 07:16 PM
  4. Finding the last entry in a row
    By mikelee101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2005, 04:11 PM
  5. finding duplicate entry
    By anil in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-02-2005, 02:06 AM

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