Thank very much for the great help...

"Sandy Mann" wrote:

"Ken Johnson" wrote in message
...
On Apr 23, 7:04 am, Pedro S. wrote:

Hi Pedro,

=IF(COUNTIF(A1:A3,"*<*")0,"<","")
&ROUND(AVERAGE(IF(LEFT(A1:A3,1)="<",VALUE(MID(A1:A 3,2,255)),A1:A3)),2)

for two dp

Ken Johnson

Hi Ken,

You not only caught me stealing your formula but you beat me to is as well!
<g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk