In article ,
"Sam via OfficeKB.com" wrote:

I forget to say why I tweaked nested LEFT Function in Formula - there are a
couple of Input cells with single digits, so they were tweaked with LEFT(B$1,
1). The Formula remains as your Posting for all double digit values. Based on
the values shown in my Posting your Formula was spot on!

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.

Hope this helps!