How can Excel check how many elements of column A are in column B? Just find out the amount, not compare the same values. It's about numbers. In general, the idea is as follows: find out the percentage of matching elements of the columns
1 answer
Array formula:
=小校袦袦(小效衼孝袝小袥袠(B1:B10;A1:A10))
The array formula is entered by pressing Ctrl + Shift + Enter at the same time. The formula must be enclosed in braces  {= formula}
The formula considers all matches. Those. if column A has two identical values, an invoice will be generated for each of them.
