Compare Two Columns
 

Hi Folks - I have data like this:

A B
34 56
blank 44
23 blank
blank blank


When both columns have numbers, condition is TRUE, other wise FALSE. I've
experimented with ISNUMBER and ISBLANK with out luck. Any ideas? Thanks.


--
Michael

Compare Two Columns
 

=count(a1:b1)=2

Would be one way.



Michael Laferriere wrote:

Hi Folks - I have data like this:

A B
34 56
blank 44
23 blank
blank blank

When both columns have numbers, condition is TRUE, other wise FALSE. I've
experimented with ISNUMBER and ISBLANK with out luck. Any ideas? Thanks.

--
Michael

--

Dave Peterson

Compare Two Columns
 

Try

=AND(ISNUMBER(B1),ISNUMBER(A1))



"Michael Laferriere" wrote:

Hi Folks - I have data like this:

A B
34 56
blank 44
23 blank
blank blank


When both columns have numbers, condition is TRUE, other wise FALSE. I've
experimented with ISNUMBER and ISBLANK with out luck. Any ideas? Thanks.


--
Michael

Compare Two Columns
 

Try =AND(a1<"",b1<"")
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Michael Laferriere" wrote:

Hi Folks - I have data like this:

A B
34 56
blank 44
23 blank
blank blank


When both columns have numbers, condition is TRUE, other wise FALSE. I've
experimented with ISNUMBER and ISBLANK with out luck. Any ideas? Thanks.


--
Michael

Compare Two Columns
 

This is a good solution based on the OP's data set. However, there may be a problem when the data set changes to include *text* and the OP still wants

When both columns have numbers, condition is TRUE ...... <<

Just my 2 cents.

Epinn

"john the confused" wrote in message ...
Try =AND(a1<"",b1<"")
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Michael Laferriere" wrote:

Hi Folks - I have data like this:

A B
34 56
blank 44
23 blank
blank blank


When both columns have numbers, condition is TRUE, other wise FALSE. I've
experimented with ISNUMBER and ISBLANK with out luck. Any ideas? Thanks.


--
Michael

Compare Two Columns
 

I better elaborate. When I said "text" I meant "not numbers" e.g. abc, xyz.

If the OP has numbers in *text format*, (i.e. format the cell as text and then key in 123 which will be left aligned), then John's formula will be able to catch it whereas the other formulae won't.

It all depends on what kind of data set the OP has and what he/she truly wants.

I felt like picking my brain and sharing what I saw. I am always amazed by the fact that there are so many ways to solve a problem in Excel.

Thank you for reading.

Epinn

"Epinn" wrote in message ...
This is a good solution based on the OP's data set. However, there may be a problem when the data set changes to include *text* and the OP still wants

When both columns have numbers, condition is TRUE ...... <<

Just my 2 cents.

Epinn

"john the confused" wrote in message ...
Try =AND(a1<"",b1<"")
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Michael Laferriere" wrote:

Hi Folks - I have data like this:

A B
34 56
blank 44
23 blank
blank blank


When both columns have numbers, condition is TRUE, other wise FALSE. I've
experimented with ISNUMBER and ISBLANK with out luck. Any ideas? Thanks.


--
Michael