Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate and IF?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate | Excel Discussion (Misc queries) | |||
concatenate every second row to first row | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Un-concatenate | Excel Discussion (Misc queries) | |||
Un - Concatenate ? | Excel Worksheet Functions |