excel get unique values from column formula
{=INDEX(list,MATCH(0,COUNTIF($D$4:D4,list),0))}excel get unique values from column formula
{=INDEX(list,MATCH(0,COUNTIF($D$4:D4,list),0))}xl get unique values
Function DistinctVals(a, Optional col = 1)
Dim i&, v: v = a
With CreateObject("Scripting.Dictionary")
For i = 1 To UBound(v): .Item(v(i, col)) = 1: Next
DistinctVals = Application.Transpose(.Keys)
End With
End Function
'-----------------------------------------------------------------------
'If you happen to have Office365, the above function can be shortened
'to make use of the Office365 worksheet function 'UNIQUE()' instead
'of the dictionary:
Function DistinctVals(r As Range)
DistinctVals = WorksheetFunction.Unique(r)
End FunctionCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
