Hi Domenic,

Thank you very much for additional assistance and great working Formulas.

Cheers
Sam

Domenic wrote:
An alternative to the solutions provided by Biff and Don would be to
change the formula to return a blank instead of #N/A...

1) Select NewSheet!B8:L8
2) Enter the following formula:
=IF(COLUMN()-COLUMN(B8)+1<COUNTIF(Range,A8)+(FirstRow=""),TRANS POSE(Array
2-Array1)-1,"")
3) Confirm with CONTROL+SHIFT+ENTER
In this case, there would be no need to use conditional formatting.

Hope this helps!


--
Message posted via http://www.officekb.com