Hi all

We don't have to disagree on whether the first one will work with text, I
was a little fast on the draw, it does work for text.

And I like the additional point about the limits of DELTA. But I was glad
to see someone find a use for DELTA, I sure there are others but it usually
seems a little longer that other solutions.

Cheers,
Shane Devenshire


"Mike H" wrote:

Shane,

You missed a major disadvantage of DELTA is that it can only take 2
arguments and would become more trouble than it's worth with the fiddling
about you'd have to do when trying to evaluate more than 2. The only reason I
offered it was because th OP specified 2 numbers.

We'll disagree about whether =(A1=B1)+1 can handle text, I remain of the
opinion it can :)

Mike




"Shane Devenshire" wrote:

Hi,

One advantage in using COUNTIF is that it will work for Text, Numbers, or
Dates

One advantage in using =1+(A1=A2) or DELTA is that the cells don't need to
be adjactent, but both of these don't work for text.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dave" wrote:

Hello,

two number in (say) a1 & b1

In another cell If the numbers are different how can i get Excel to return
1 or if the numbers are the same 2


d