List not omitting blank cells....??

  • Thread starter Thread starter malik641
  • Start date Start date
M

malik641

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?
 
A cell with a formula cannot be blank.

Your formula only makes it look blank.


Gord Dibben Excel MVP
 
.............damnit

Well thanks for that info, I'll find another way to deal with that
problem
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Omit empty cells? 0
Remove punctuation mark, Split cells & average accross column 4
Validation List 2
list from empty data cell source 1
How do I put a blank value in a cell not using "" in a formula 2
Spurious Formula Omits Adjacent Cells 2
Excel Named Ranges and Conditional Format 3
Create a Condensed List from Imported Data 3

Back
Top