How to autofill a cell with an incrementing number for each time a value appears in another column

Column formula request:

I'm trying to assign a numeric value to a cell and increment up for each instance a code shows up in another column.

For example, if a column has NH002 in it 4 times, the first time, the cell should have a value of 1, and repeat until it gets to 4. Once NH003 starts, it would start over at 1 and count up.

I figured "=IF(" would be the start, but not even sure where to go from there to get it to increment.

Find more posts tagged with

Formulas

Accepted answers

Paul H

@dhall

If I understand correctly from you other post you are getting these submission weekly so you could use the week number based on submission date. Using min(collect to find the first entry and subtract it from the current weeknumber

All comments

Intern98

=IF( ([col]@row="NH002"),Count ([helper]1:[helper]@row) ,"")

helper:

=IF( [col]@row="NH002",1,"")

dhall

Thanks @Intern98 , this works to an extent. I would need to adjust the formula every time we get to a new code specifically for that row or series of rows. I wouldn't be able to make it a column formula.

Paul H

@dhall

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, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.