Counting blankvalues in column of an Excel

• ns.sharath

  SSC Eights!

  Points: 876

  More actions

  January 9, 2009 at 4:06 am

  #198197

  Is there any way to count blank values in column of Excel ?

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 9, 2009 at 1:10 pm

  #924532

  ns.sharath (1/9/2009)

  ---

  Is there any way to count blank values in column of Excel ?

  Did you try:

  select count(*) from sheet1$ where column1 is null;

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/