Good Afternoon

I have an excel spreadsheet which shows all the active vacancies for each
department.

December January
Detail (inc date) Forecast Detail (inc date) Forecast
Engineering Portfolio Lead 1 Mechanical Engineer (FRS) 1
Mechanical Engineer (G&A) 0
C&I Engineer 1


Total 1 2


Those that are active have a number in the column next to them. Those that
have been filled have a zero in the column next to them



Please can you tell me if there is any way to create a list of all those
vacancies that are active in another cell? (bearing in mind that we could
have as many as 15/20 vacancies in one department at any one time)

Many thanks