View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Second cell in Data Validation

Yes.

Any cell but A2 or within the table range of D2:E100

Try entering Bernie's formula in B2


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 14:57:02 -0800, WFariss wrote:

Are you suggesting that I put that formula in the second cell?