View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
diam diam is offline
external usenet poster
 
Posts: 2
Default number checking

I would essentially be setting up Bingo on a worksheet. Each person would
pick 6 numbers, then as I entered numbers into a range of 50 cells, the
numbers people have picked would be marked off 1 by 1 until someone had all 6

"diam" wrote:

I would like to have a list of names associated with 6 numbers, one in each
cell. I will enter numbers in a different part of the worksheet. Is there a
formula that would check the range of numbers associated to the names with
the range of numbers I have selected and either highlight them or strike them
out?