Compare Two Columns

[Michael Laferriere]

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.

 

[Dave Peterson]

=count(a1:b1)=2

Would be one way.

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.

 

[Guest]

Try

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

 

[Guest]

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

Ice Hockey rules (especially the Wightlink Raiders)

 

[Epinn]

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

Just my 2 cents.

Epinn

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

Ice Hockey rules (especially the Wightlink Raiders)

 

[Epinn]

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


Just my 2 cents.

Epinn

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

Ice Hockey rules (especially the Wightlink Raiders)