What do you want to do? Count the number of times 1, 2, etc appear in
F1:F2999?

Enter =COUNTIF(F1:F2999,"1") etc.
--
Brevity is the soul of wit.


"Major Tomm" wrote:

I have 6 fields numbered 1 thru 6, I want each to look for its own number in
a column even if there are multiple numbers in it...
A1 to look through F1 thru F2999 which can contain any combination of
numbers1 thru 6.
Say F32 has the numbers 1, 3, 5, can a formula recognize each of those
numbers?