Results 1 to 11 of 11

Location of the last occurrence of month in range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    108

    Location of the last occurrence of month in range

    Hi -

    How do you find the last of occurrence of the month in Column A. Please see below print screen.

    Based on the print screen 3 is the location of the first occurence of January how about the last occurrence? what is the formula that I'm
    going to use?

    I've already tried =MATCH("January",A1:A22,1) but its giving me 22 which is suppose to be 8.

    Need help please

    Thank you

    untitled.JPG
    Last edited by Hudas; 02-24-2012 at 04:52 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