Hi
Use COUNTIF() and just count the value of a cell within a column:
B3 =COUNTIF($D$3:$D$31,A3)
E3 =COUNTIF($A$3:$A$31,D3)
Copy the formulas to the end of your list. It will return 0, if there's no match.
You are using a text-format for numbers! I wonder why. Be aware that the above formulas if looking for a text won't find a match in case the same value exists as number (and viceversa). It will return 0.
|