New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Excel 2010 query parameters based on cell value if NULL

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Excel 2010 query parameters based on cell value if NULL

Postby ltworf » Thu Dec 22, 2011 12:18 pm

Excel 2010 query parameters based on cell value. Make is not null if cell is blank.
What should I put in the. Criteria section. IE for field Region I put 2 parameter [Enter A Region] and in the or criteria I tried like [Enter A Region] is null. But I get a syntax err msg
  • 0

ltworf
Rookie
 
Posts: 1
Joined: Dec 22, 2011
Reputation: 0

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 266 guests