Help With Formula to collect names of people if they are appointable after interview

Occasional Visitor

Hi All,


So I'm tasked with a recruitment spreadsheet and I'm finding it difficult to get a formula to collect all candidates that are appointable onto a summary page. I have 4 tabs Nottm, Northants and Leicester. In these its broken down into tables with interview info. If someone is successful in column N we will put "Yes" all I want is to then get their name from the respective row to appear in the name section of the summary page which is Column D.


This would have to gather all 'Yes' names from all tabs so we can then track their recruitment


Any help would be much appreciated

Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
People Web Part
LukeSplaz in SharePoint on
3 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies