View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default 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