excel - Excel: account on two criteria (function 8 function)

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)

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.