Hi all.

I have a large spreadsheet that has all 450 jobs in my place of work listed down the left hand column.

I need to be able to list the jobs that are currently vacant and sort them by seniority. I can do this with the below IF function but it is then returning a lot of 0 for the jobs that are filled (as iwold expect.) is there any way to get the 4 empty jobs in this seniority listed with out the others?

IF('doc1'!r5="gapped",IF('Doc1'!j5="supervisor",'doc1'!h9,),)

As I say it works and lists the correct info but rather have 440 cells saying "0" and having to find the 4 that say which job is empty I would like to produce a list of the jobs which are empty

Return this
Shop 1
shop 3
Shop8
Shop10


Rathern than
return this
0
0
0
0
0
0
0
Shop 1
0
0
0
0
0
0
0
0
shop3
etc

Thnks for your help

Giles
[tr]
[td][/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[/tr]
[/table]