List not omitting blank cells....??
 

I'll choose like $A$1:$A$100 as the list and the "Ignore blank cells" is
checked, but when I create the list, all of the blanks are still
included.

The list of $A$1:$A$100 contain if statements of

=IF(Main!$A1="","",Main!$A1)

Does that make a difference?
Can anybody help?


--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=383641

A cell with a formula cannot be blank.

Your formula only makes it look blank.


Gord Dibben Excel MVP


On Thu, 30 Jun 2005 12:56:02 -0500, malik641
wrote:


I'll choose like $A$1:$A$100 as the list and the "Ignore blank cells" is
checked, but when I create the list, all of the blanks are still
included.

The list of $A$1:$A$100 contain if statements of

=IF(Main!$A1="","",Main!$A1)

Does that make a difference?
Can anybody help?

............damnit

Well thanks for that info, I'll find another way to deal with that
problem


--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=383641