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
On Thu, 30 Jun 2005 12:56:02 -0500, malik641
<[email protected]> 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
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
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
<[email protected]> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks