I have a dataset containing a list of check numbers.

Check
111
111
111
222
222

I am trying to have a new column in my dataset that would give me the 1st, 2nd, ....nth instance for every check. The output would like something as below,

Check Instance
111 1
111 2
111 3
222 1
222 2
Feb 2, 2023 in Others 361 views

## 1 answer to this question.

You can use the COUNTIF function with an expanding range to generate a rolling count for a particular instance that appears in a range of cells.

```=COUNTIF(A\$2:A2,A2)
```

• 63,420 points

## How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

## How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK(\$C:\$C,\$C2,4),0)) To divide into whichever many ...READ MORE

## How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE