Use MATCH to find the last position of a matching value.

earl_bennett

In the period column I have a MATCH formula to get the position of the matching value in Current Month.

=IFERROR(MATCH([Current Month]@row, June@row:May@row, 0), "")

In this case the value returned is 5.

How would I get the position of the last matching value, which would return 8?

Thank you!

Find more posts tagged with

Accepted answers

All comments

Samuel Mueller

@earl_bennett I think would need a helper row that has the number 1-8 in the months. So june- 1, july- 2, etc.

Then you would need a formula such as

=MAX(COLLECT(june$1:january$1, june@row:january@row, [Current Month]@row))

Where June$1:January$1 is your helper row with the numbers 1 through 8.

You would not be able to make this a column formula

earl_bennett

Of course... Should have thought of that myself, thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.