Formula to copy data based on criteria

[Glenn Kennedy]

My brain hurts this morning. I've been trawling the web and can't see a solution for a relatively simple criterion-based copy/paste. The spreadsheet shows clearly the source data, the criteria used and the desired end result.

In short, if I want to select data in cells in one column, if the values in another column meet a criterion and copy the selected values to another location.

Can you help me (again...)??

[Pete_UK]

See attached file. I've used this formula in F5:

=IF(A5="","-",A5&"_"&COUNTIF(A$5:A5,A5))

which is copied down the column beyond your data (the hyphens show how far). Then I've set your table up in columns N to Q (in blue), with this formula in N18:

=ROWS($1:1)

and this one in O18:

=IFERROR(INDEX($D:$D,MATCH(O$17&"_"&$N18,$F:$F,0)),"")

which is copied across to Q18. Copy N18:Q18 down as far as you need to.

Hope this helps.

Pete