I need to find the mode of a group of values in an array in VBA. Is there any way to do this beyond an extensive if-then statement?
I need to find the mode of a group of values in an array in VBA. Is there any way to do this beyond an extensive if-then statement?
[vba]
MsgBox Application.Mode(ary)
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber