Tuesday, March 6, 2012


for next time, codecademy: Return

Dim greeting As String
Sub Initialize()
    greeting = "hello"
End Sub
Sub Greet()
    Dim greeting As String
    Debug.Print greeting
End Sub
Sub sayHelloTo(name)
    Debug.Print "hello " & name
End Sub
Sub RunMe()
    'Initialize
    'Greet
    sayHelloTo "Josh"
End Sub

=INDEX(Data,SMALL(IF(Data>0,{1;2;3;4;...20}, FALSE),{1;2;3;4;...20}))

=IF(ISERR(SMALL(IF(Data>0,ROW(INDIRECT("1:"&ROWS(Data)))),ROW(INDIRECT("1:"&ROWS(Data))))),"",INDEX(Data,SMALL(IF(Data>0,ROW(INDIRECT("1:"&ROWS(Data)))),ROW(INDIRECT("1:"&ROWS(Data))))))


=INDEX(data,SMALL(IF(MATCH(data,data,0)=ROW(INDIRECT("1:"&ROWS(data))),MATCH(data,data,0),""),ROW(INDIRECT("1:"&ROWS(data)))))

=INDEX(data,SMALL(IF({1,1,1,1,5...}={1...19},MATCH(data,data,0),""),{1...19}))

No comments:

Post a Comment