Hi folks,

As a hobby, I've been tracking PB numbers picked over the past couple of
years. I have the numbers listed in each cell in three columns in this
format.
10 25 35 38 41 PB 23 (last night's pick). Am trying to pick out each
separate number with this formula, for each number between 1-55. To find 01
=
=COUNTA($B$1:$B$63,$F$1:$F$63,$J$1:$J$63,1)-11-21-31-41-51. This excludes
all other numbers ending with a 1, except for 01.

Only problem is that I can't separate out the PB number pick if that number
is one Tried numerous variations of formulas, changing how the PB number
shows ect. I realize I should have dedicated a separate column for the PB #,
but it's too late now, with over 160 sets of numbers already typed in.

Any ideas on how to complete this formula? Or, is there a better argument to
use?

TIA,

Bob