Forum Discussion
Formula for Vacancies
Hello, I am trying to create a formula that will link a total number of "vacancies" per position onto a separate excel sheet. Sheet 1 ...
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.