Dear community,
I need a formula that would count how many times an element of one column co-occurs with another element in each row. The input is represented in Figure 1. The result (see Figure 2) could look as follows. The formula counts how many times H* co-occurs with n and p. In this case, it would be 1 for n and 2 for p. The same calculation would be performed with L+H*. I think that the countifformula can be applied here however, I do not know how to create a link between the two elements, n and p.
=COUNTIF(F2:F343; "H*"//how to link it with p/n?).
I am glad about every feedback and would be very grateful if you could help me. I work with a rather big data bank and. It is barely possible to count the elements manually and without making a mistake.
Figure 1:
<tbody>
</tbody>
Figure 2:
<tbody>
</tbody>
I need a formula that would count how many times an element of one column co-occurs with another element in each row. The input is represented in Figure 1. The result (see Figure 2) could look as follows. The formula counts how many times H* co-occurs with n and p. In this case, it would be 1 for n and 2 for p. The same calculation would be performed with L+H*. I think that the countifformula can be applied here however, I do not know how to create a link between the two elements, n and p.
=COUNTIF(F2:F343; "H*"//how to link it with p/n?).
I am glad about every feedback and would be very grateful if you could help me. I work with a rather big data bank and. It is barely possible to count the elements manually and without making a mistake.
Figure 1:
pre-nuclear/ nuclear | Symbol |
p | H* |
n | L+H* |
p | H* |
p | L+H* |
n | H* |
<tbody>
</tbody>
Figure 2:
Symbol | n | p |
H* | 1 | 2 |
L+H* | 1 | 1 |
<tbody>
</tbody>