View Single Post
 
Old 11-15-2017, 06:07 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Say your results table is in a sheet called "Results", with column headers starting at A2 and figures below.

Add a "helper" formula in column F at F3,

=A3&"_"&COUNTIF(A$3:A3,A3)

copied down as far as you want in order to capture future data. (You can hide this column)

Now in the sheet for Item A, beginning at A2 enter formula:

=IFERROR(INDEX(Results!B:B,MATCH("A"&"_"&ROWS($A$2 :$A2),Results!$F:$F,0)),"")

copied across 4 columns and down as far as you want to capture future data.

Repeat for other items replacing the "A" with the corresponding Item.

Now when you type new row in Results sheet, it would populate in next row of corresponding item.
Reply With Quote