Forum Discussion
Formula for Vacancies
Have you tried a PivotTable? Put Position & Status in the Row field, then drag Status from the Field List into the Values field to get your summary.
As your status changes, just refresh the PT to update.
Thank you for the thought. I have been working with it this morning and it will not separate the information correctly. There are spaces throughout the document to separate departments and positions and it wants to create a sum and I want the positions listed separately to see how many vacancies per position.
Thanks
If your data is set up with spaces in between departments, then there's not much you'll be able to do other than manually.
You'd be better off by removing the gaps, then Excel will see it as one, continuous data set. Much like a database.
