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$44 0)-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(Dr aft!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?

--
Message posted via http://www.officekb.com

You can't combine them.

See this:

http://contextures.com/xlDataVal03.html

Biff

"Jerkyboy via OfficeKB.com" <u25339@uwe wrote in message
news:64e08c124e9e9@uwe...
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$44 0)-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(Dr aft!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?

--
Message posted via http://www.officekb.com