How do do numbering/sequencing for sets of the same column values? For example:

```Col1 Col2
Andy  1
Bill  1
Andy  2
Bill  2
Bill  3
Bill  4
```

Since Andy got 2 values, I want to number it 1 and 2 in Column 2. For Bill, I want to number it 1, 2, 3 and 4, and so on.

Jan 3 in Others 79 views

You can accomplish this with countif and a sliding range :

```   A        B
1  val1     =COUNTIF(\$A\$1:A1, A1)
2  valx     =COUNTIF(\$A\$1:A2, A2)
```

And so on.

The formula in column B can be automatically filled in or moved down into the column. COUNTIF counts up the matching values in the previous set in this fashion; it anchors to the top of the range and only scans down to the value we are numbering.

• 60,280 points

Best way to get average values within a specific set of time(say, date or year) using MySQL or Rails

I don't think post-process is what you ...READ MORE

how to show the <meta> values of yoast seo with some function?

check this folder : wordpress-seo\src\presenters\open-graph you can ...READ MORE

Ordering by the order of values in a SQL IN() clause

We can use expressions as well in ...READ MORE

Ordering by the order of values in a SQL IN() clause

Use MySQL FIND_IN_SET function: SELECT * ...READ MORE

Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count ...READ MORE