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

# Excel: account on two criteria (function 8 function)

Author

Date

Category

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?

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.

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.