Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Function won't fire
Can anyone tell me why the following function to test the uniqueness o values in a (single and same) range fails to fire? It's based on th Worksheet Array formula *=MAX(COUNTIF(rng,rng)) *returning 1 fo "unique", otherwise "not unique". Function UniqueTest(rng1 As Range, rng2 As Range) As String Application.Volatile x = Application.Evaluate("Max(Countif(rng1,rng2))") If x = 1 Then UniqueTest = "Unique" Else UniqueTest = "Not Unique" End If End Function and neither does ... Function UniqueTest2(rng1 As Range, rng2 As Range) As String Application.Volatile x = [Max(Countif(rng1,rng2))] If x = 1 Then UniqueTest2 = "Unique" Else UniqueTest2 = "Not Unique" End If End Function TIA Myle -- Myle ----------------------------------------------------------------------- Myles's Profile: http://www.excelforum.com/member.php...fo&userid=2874 View this thread: http://www.excelforum.com/showthread.php?threadid=52299 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set out a fire risk documunt | Excel Discussion (Misc queries) | |||
Code will not fire | Excel Programming | |||
Event doesn't fire | Excel Discussion (Misc queries) | |||
Custom function does not fire | Excel Programming | |||
Workbook_SheetChange will not fire | Excel Programming |