Creating List from Table

I would like assistance with generating a list in my worksheet from an existing table that contains 18 rows and 3 columns. The table is populated with results from formulas in each cell that in this case, identify whether a golf “skin” was won. The 18 rows in the table represent one row for each of the 18 holes on the course.

Rather than displaying the table, I want to generate a list of only the rows in the table that show results (i.e. only those holes where a skin was won). The list needs to be able to recognize the first row in the table that produces results and display the information as the initial entry in the list. I then need the list to evaluate the next row from the table that contains results and display those results as the second entry in the list. For example, if a skin was won on the first hole, then the list would display information from the table from row 1. If a skin was not won until the fifth hole, then the list would recognize that results from the first hole have already been identified and displayed and that the results from the fifth hole need to be displayed next from row 5 of the table, and so on.

In simpler terms, I need to create a list that only displays the rows of the table where a skin has been won. It would be excellent if this list could be created so that it is dynamic in a sense regarding the number of entries in the list. For example, in week one, there were three skins won so the list would only display three rows. However, in week two, there were eight skins won so the list would need to display eight rows.
I’ve been racking my brain on this one and I’m sure there is a simple solution, but it’s just not coming to me. Any help would be greatly appreciated!

Thank you I will give this a try.

Ford,
I have been able to get the array formula you suggested to work in a test worksheet, however I have not been successful achieving results in the worksheet I’ve created to generate the list of results. I’ve taken care to create and enter the array formula per the example you provided and I’ve made certain to press CTRL+SHIFT+ENTER so that the formula functions as an array function.

I’ve attempted to recreate the worksheet below with the actual and relevant cell addresses and content. In the event I cannot get the table below to appear correctly in the body of this reply, I have also attempted to attach a screen shot of my worksheet and attach as a *.jpg file.

In cell Y220 of my worksheet I’ve entered the following array formula following your suggestion and have activated the array formula by pressing CTRL+SHIFT+ENTER:
{=IFERROR(INDEX($AD$220:$AD$237,SMALL(IF(AD$220:AD$237<>"",ROW($AD$220:$AD$237)-2),ROWS($A$1:A1))),"")}

However, the formula only produces a “blank” result. The formula does not produce an error so it appears to me that it has been written properly and is simply evaluating the data and returning a blank.

I’ve also run the Evaluate Formula function from the Formulas ribbon. When I get to the sixth level of evaluation I see the following: IFERROR(INDEX($AD$220:$AD$237,219),””). I see that the number “219” (I am assuming this is a reference to a row number based upon results of the ROWS function as part of the above formula.
Perhaps I’ve not entered the formula correctly. Thoughts?

AB AC AD
220 Hole 1
221 Hole 2 Bates, Kevin 2.5
222 Hole 3
223 Hole 4
224 Hole 5 Reed, Steve 2.5
225 Hole 6
226 Hole 7 Graham, David 2.5
227 Hole 8 Reed, Steve 2.5
228 Hole 9
229 Hole 10 Ritacca, Mike 2.5
230 Hole 11
231 Hole 12
232 Hole 13 Randle, Tom 2.0
233 Hole 14
234 Hole 15
235 Hole 16 Steele, Phil 3.5
236 Hole 17
237 Hole 18 Gesquiere, Ron 2.5

The attempt to display a table in my reply was feeble and appears inaccurate. The attached screen.jpg file represents my table and data more accurately. If you are unable to see or open that I'll be happy to send a sample spreadsheet. Thanks! P.S. I tried your recommended adjustment above to no avail. I believe the range references are off a bit?

Please see attached. The cell highlighted in yellow ("September 20, 2014" worksheet tab, cell AL220) contains the formula. Thanks!

Thanks. I was able to see results, however, they don't appear to be consistent with expectations. I believe I have entered the formulas properly beginning in cells AK220 for the name and AL220 for the score, but perhaps I am still making an error. I've attached a revised version of the file so you may view the results.

Perfect that did it! I appreciate your time and help!