Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How can I make this formula respond ONLY to two-digit values in a range? (Array Entered)
=IF(MAX(COUNTIF(Data1,Data1))1,"Y","N") Where the values may also be values-stored-as-text. This returns "Y" because of the two 15's 1589 15 1789 189 4 189 2 15 6 This returns "N" ignoring the two 189's 1589 16 1789 189 4 189 2 15 6 Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
No dupes | Excel Programming | |||
macro for dupes | Excel Discussion (Misc queries) | |||
No dupes | Excel Programming | |||
Checking for Dupes | Excel Discussion (Misc queries) | |||
Marking Dupes | Excel Programming |