Show 3 cells across a row on shhet 2 w/ no gaps IF an X is in column C

**Billbo** · 05-09-2012, 11:21 AM

This is an inspection form, but there's so much data on it that its a little small to print & leave for the builders. I want sheet 2 "Print Tag" to show the code and code reference numbers if an X is in the fail column. The thing is, there can't be any gaps on sheet 2. If the 5th, 12th, and 17th codes fail I need them to be listed one on top of the other on sheet 2. I can make an extra sheet just to make the formula work if need be.

**NBVC** · 05-09-2012, 11:33 AM

In A10 of E1-2 sheet enter:

=IF(C10="x",COUNT(A$9:A9)+1,"")

copied down

Then in Print Tag sheet, B21 enter:

=IFERROR(INDEX('E1-2'!E$10:E$55,MATCH(ROWS($B$21:$B21),'E1-2'!$A$10:$A$55,0)),"")

copied down.

Do similar for other column adjusting the INDEX range.