COUNTIF Formula to Return Multiple Values in a Single Column

**TommyK25** · 07-05-2013, 04:37 AM

Good morning all,

I made a similar request on here a few weeks ago which was very kindly solved with no issues whatsoever. Unfortunately however, I have been unable to implement the forumla again due to a third column being involved (and my profound lack of Excel knowledge

), whereas before there were only 2 columns.

I've attached an example spreadsheet to assist my explanation (which are notoriously bad) - basically the formula would lookup and match the ID number and return the 'Actions' value - which are listed as a column, sometimes several times against 1 ID - and return them across in a row.

Any help would be much appreciated guys - please let me know if you need any further info.

Many thanks,

Tom

**XOR LX** · 07-05-2013, 04:44 AM

Hi,

In B2 enter this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER) and copy down and across:

=IFERROR(INDEX($K$1:$K$19,SMALL(IF($J$2:$J$19=$A2,ROW($J$2:$J$19)),COLUMNS($A$1:A$1))),"")

Regards