For example, there is a table with two columns:

VRT | 1

VRT | 1

VRT | 2

DMT | 1

DMT | 5

Tim | 2

Tim | 4

Tim | 5

VRT | 3

DMT | 1

DMT | 2

Tim | 2

I need to calculate how many numbers for each block. For example, how much 1 and 2 at VRT, how much 5 in DMT, etc.

result should be:

VRT1 = 2 pcs

VRT2 = 1 pcs

VRT3 = 1 pcs

DMT1 = 2 pcs

DMT5 = 1 pcs

DMT2 = 1 pcs

Tim2 = 2 pcs

Tim4 = 1 pcs

Tim5 = 1 pc

How to do it?

## Answer 1, Authority 100%

In my opinion it is better to use consolidated tables for such tasks.

If you want for a particular pair, it is just like this ($ A $ 1: $ A $ 12 and $ B $ 1: $ B $ 12- column values):

```
= countable ($ A $ 1: $ A $ 12; "VRT"; $ b $ 1: $ b $ 12; 1)
```

Here is an option via `countable `

for all pairs

1) We make a table of unique couples

– Copy the entire table

– Remove duplicates (data- & gt; remove duplicate)

2) Make `Schedule `

for each unique pair:

`= countable ($ A $ 1: $ A $ 12; h1; $ b $ 1: $ b $ 12; i1) `

## Answer 2, Authority 100%

Many use *Excel-2003 *, where there is no *8) *.

Replacing the missing function:

```
= dimpepros (- ($ A $ 2: $ A $ 13 = "VRT"); - ($ B $ 2: $ B $ 13 = 1))
```

with add. A column where data is linked (*= a2 & amp; B2 *):

```
= countdown ($ C $ 2: $ C $ 13; c2)
```

With the presence of clutch data, you can select unique formula:

```
= index ($ C $ 2: $ C $ 13; min (if (bid ($ E $ 3: E3; $ C $ 2 : $ C $ 13) = 0; string ($ C $ 2: $ C $ 13) -1)))
```

The massif formula is introduced simultaneously by pressing *Ctrl + SHIFT + ENTER *

without add. The column is also possible, but the formula is more complicated.

And if unique selected, then it is simple.

Yellow Range: Below will be the first unique value. To eliminate the formula you need to complicate.