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
|