View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheri Sheri is offline
external usenet poster
 
Posts: 17
Default Excluding NULL values in an Excel List

I have a listbox in an Excel Worksheet. The listbox is at position B1(eg).
The data range for the listbox is from A(1:1000). But all the cells A(1:1000)
may or may not have data. How can i filter the data in my listbox, so that it
does not have any NULL values(blank data).