Hi,
My first post and i think it is kinda simple!

I have data in the following format (example only, not real information)

Sample Criteria Cow_Sample
123456 Cow
234872 Dog
384755 cat
222222 Cow
837465 Dog
873927 Cow

I want to extract all the sample values where Criteria = "Cow"
the extracted data i want to put in a new column called Cow_Sample

all the various formula i have tried extract the data, but dont remove the blank cells, ie i get this:
123456


222222

873927

i want to get the values consecutivly, no gaps.

Im not a VBA user, ive just started to understand array formulas which i think is what i need.

many thanks!

TS