using =1+(A1=A2) or DELTA
but both of these don't work for text.

=1+(A1=A2)

Does work with text.

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
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