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 1

    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.