View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Football Express Football Express is offline
external usenet poster
 
Posts: 10
Default allowing each value to be used once

Still looking for the same result!
Is there a function / formula that will RECOGNIZE if a 3 letter word (text)
has already been used in the previous (up to 17) cell(s) in the SAME ROW and
would, in some way (ANY way), alert the inputter that the word has already
been used.
The "word" is a 3 capitalized letter abbreviation of any one of the 32
football team towns abbreviated like CHI = Chicago, PHI = Philadelphia, and
so on) and the "row" or string will grow by one cell each Sunday.
--
To those who have helped in the past and those about to help, Thank You.
There is an intregeing element to Excel that has captured me and that
stimulates my every remaining brain cell. Awesome