ivanastaylor
New Member
- Joined
- Apr 22, 2003
- Messages
- 1
I have data that has more than one number in a cell - separated by a comma. i.e. 23,2
I want to count how many times 2 occurs either alone in a cell or as part of a cell that contains a 2 separated by a comma.
I've tried
=countif(range, 2)
=countif(range, *2*)
and didn't get anywhere - any assistance?
I want to count how many times 2 occurs either alone in a cell or as part of a cell that contains a 2 separated by a comma.
I've tried
=countif(range, 2)
=countif(range, *2*)
and didn't get anywhere - any assistance?