Hi
If a set of data has two modes, eg 3,3,3,6,6,6 then the MODE worksheet
function will only report the smallest one as being the mode. Is there
some sort of work around in VBA which will allow me to report both modes ?

TIA

Andrew B