Hi Guys,
I created a formula that will list the unmatched item to column C. My problem is how to count this items.
Example:
Column A
FUR1111
FUR2222
FUR3333
FUR4444
FUR5555
Column B
FUR2222
FUR4444
Column C (Unmatched items)
FUR1111
FUR3333
FUR5555
So in this example, the total number of unmatched is 3. However i don't know how to count this through formulas.
The thing is, the column is C is composed of formulas. Is there a way to count only the result and not the formula.
Bookmarks