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}))
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment