Find the lest common string-value in a range

**ElmerS** · 02-01-2009, 05:41 PM

Hi,

Everything is explained inside the attached WB.

Thanks in advance,

Elm

**shg** · 02-01-2009, 05:55 PM

{=index(a1:a10, match(min(if(a1:a10 <> "", countif(a1:a10, a1:a10) ) ), countif(a1:a10, a1:a10), 0) )}

**ElmerS** · 02-01-2009, 06:01 PM

As alway - much obliged.

**Ron Coderre** · 02-01-2009, 06:13 PM

If NON-array solution is acceptable...try this:

Please Login or Register  to view this content.

Does that help?

**ElmerS** · 02-01-2009, 06:25 PM

As we say here - this is "More than Perfect"

Thank you.

Re: Find the lest common string-value in a range