Hi Domenic,

Thank you for further input. Great alternative solution!

Thanks
Sam

---------------------------------------------------------------------

An alternative might be as follows...

1) enter your Input cells as you would normally in Row 1

2) extract the relevant number (single or double digit) in the second
row...

B2, copied across:

=LEFT(B1,FIND("-",B1)-1)+0

3) have the formula refer to this row...

B19, copied across:

=IF(ISNUMBER(MATCH(B$2,Sheet1!$B19:$H19,0)),IF(MAT CH(B$2,Sheet1!$B19:$H19
,0)<7,IF(INDEX(Sheet1!$B19:$H19,MATCH(B$2,Sheet1!$ B19:$H19,0)+1)=B$2+1,B$
2&"-"&B$2+1,""),""),"")

This way you could dispense with having to alter the LEFT function,
depending on your data. And, if you wish, you can hide the second row
by either hiding the row itself or using conditional formatting and
choosing 'White' as your font color.

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