Results 1 to 11 of 11

Location of the last occurrence of month in range

Threaded View

Hudas Location of the last... 02-24-2012, 04:33 PM
NBVC Re: Location of the last... 02-24-2012, 04:41 PM
Fotis1991 Re: Location of the last... 02-24-2012, 04:43 PM
Hudas Re: Location of the last... 02-24-2012, 04:47 PM
Fotis1991 Re: Location of the last... 02-24-2012, 04:50 PM
NBVC Re: Location of the last... 02-24-2012, 05:09 PM
Hudas Re: Location of the last... 02-24-2012, 05:26 PM
Hudas Re: Location of the last... 02-27-2012, 10:08 AM
NBVC Re: Location of the last... 02-27-2012, 10:09 AM
Hudas Re: Location of the last... 02-27-2012, 10:24 AM
NBVC Re: Location of the last... 02-27-2012, 10:34 AM
  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