Create a column on a new sheet from filter list

[DJMini]

Hi All,
Wonder if you could help.

I am trying to transfer the list of results from a filter on a column on one sheet and display the list onto another column on another sheet.
For example:

to this

Any ideas?

Thanks

 

[Fluff]

How about
=IFERROR(INDEX(Pcode!$G$2:$G$100,MATCH(0,INDEX(COUNTIF(A$1:A1,Pcode!$G$2:$G$100),0),0)),"")
change sheet name in red to suit

 

[DJMini]

Hi Fluff, Thanks for the help, that appears to have worked!

Another issue I have.
I have created this formula: =COUNTIF(AND('Four Winds complete 5837 BS5837'!G:G=A2),('Four Winds complete 5837 BS5837'!K:K=D1)),0),"")
Which takes the results of the formula that you created and uses them as one of the parameters for a countif function. Now, what I am trying to get from the above formula is to count how many "English Oaks" are "Early Mature" (for example). Can you see what I am doing wrong?

Sorry to bother you with this!

 

[DJMini]

This is the Four Winds complete 5837 BS5837 sheet

 

[Fluff]

Try
=COUNTIFS('Four Winds complete 5837 BS5837'!G:G,A2,'Four Winds complete 5837 BS5837'!K:K,D1)

 

[DJMini]

Thanks Fluff,

One thing...
If the =IFERROR(INDEX(Pcode!$G$2:$G$100,MATCH(0,INDEX(COUNTIF(A$1:A1,Pcode!$G$2:$G$100),0),0)),"") formula is to be used for a column with more than 100 entries do i change the formula to =IFERROR(INDEX(Pcode!$G$2:$G$300,MATCH(0,INDEX(COUNTIF(A$1:A1,Pcode!$G$2:$G$300),0),0)),"")
I have done this and have ended up with duplicates

 

[Fluff]

Your change is correct, but as you are starting the list in A3, rather than A2 you also need to change this
=IFERROR(INDEX(Pcode!$G$2:$G$300,MATCH(0,INDEX(COUNTIF(A$2:A2,Pcode!$G$2:$G$300),0),0)),"")

 

[DJMini]

Thanks,

Do you know why there is always a 0 at the end of the column? anyway to get rid of it?

 

[Fluff]

It's because the range you are looking at contains blank cells at the end.
Change the $G$300 to the last row of data.