Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allowing only 1 check box to be ticked | Excel Discussion (Misc queries) | |||
DropDowns - allowing each value to be used once | New Users to Excel | |||
Allowing Only Certain Entrees | Excel Worksheet Functions | |||
Allowing a leading zero if there is one | Excel Discussion (Misc queries) | |||
Allowing for a range using COUNTIF | Excel Worksheet Functions |