Help with a formula....

[Alex Caldecott]

Morning!

Is there a formula that I can put in B6 of the Ashtead tab that will search column B of the Plot summary tab to find all the Ashtead types, and then pull the plot numbers from column A into a list like 45,46,47,48 etc....

Appreciate any help!!

Cheers.

 

[Fluff]

How about

=TEXTJOIN(", ",,FILTER('Plot summary'!A11:A1000,'Plot summary'!B11:B1000=B5))

 

[Alex Caldecott]

Thanks for the reply, doesn't seem to work for me though

 

[Fluff]

In what way?

 

[Alex Caldecott]

When I paste the formula into cell B6 of the Ashtead tab it just displays exactly as the formula, doesn't seem to do anything.... sorry if I'm doing something wrong? My skills with Excel are non-existent

 

[Fluff]

Make sure that the cell is formatted as general & then try again.

 

[Alex Caldecott]

Awesome! Thanks so much!

 

[Fluff]

You're welcome & thanks for the feedback.