Combining Two Formulas to One

[Jerkyboy via OfficeKB.com]

I have an Excel spreadsheet that I created drop down lists on. I am creating
dependent lists and hiding previously used items. I can get both of these
formulas to work independently, but I 'm not sure how to combine these into
one formula, so I can use it as a Data Validation Source.

=OFFSET(Players!$D$2,0,0,COUNTA(Players!$D$2:$D$440)-COUNTBLANK(Players!$D$2:
$D$440),1)
(This removes the selected players from the drop down list)

=OFFSET(INDIRECT(Draft!$D2),0,0,COUNTA(INDIRECT(Draft!D2&"Col")),1)
(This filters the drop down based on another drop down selection in another
column)

Is there a way to combine these formulas together?

I've tried putting them both in the Source field of the Data Validation as
separate formulas, but the the drop down stops working. Any suggestions?

 

[Biff]

You can't combine them.

See this:

http://contextures.com/xlDataVal03.html

Biff