#### jmallory76

##### New member

- Joined
- Aug 20, 2013

- Messages
- 2

- Reaction score
- 0

- Points
- 0

I'm having trouble with this, and hoping someone can point me in the right direction with a formula.

For instance A1 contains the following numbers:

15;17;20;45;48;61;69;72;76;77;80

I would like a formula that would see that A1 contains the values 15, 20, 45 and 69 for example and return the amount of matches found. So in cell B1, I would get the value 4 (the amount of my desired numbers found).

If I only requested to see if A1 contains the values 17 and 45...B1 would return the value 2 with my desired formula.

Thank you in advance for any help or insight.