software

if I have data in cells A2 through M2 is there a formula I could use to
identify and differences in the data.

Ex.

A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2
7 7 7 7 7 8 7 7 7 7 7 7 7

Is there a formula that would look at everything in this row and if it sees
the same value it would display a quot;yesquot; and if not it would display a quot;noquot;.
Since the example has an quot;8quot; in F2 then it would display a no.

Thanks,

Hi!

Try this:

=IF(COUNTIF(A2:M2,A2)=13,quot;Yesquot;,quot;Noquot;)

Biff

quot;Crawdaddyquot; gt; wrote in message
...
gt; if I have data in cells A2 through M2 is there a formula I could use to
gt; identify and differences in the data.
gt;
gt; Ex.
gt;
gt; A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2
gt; 7 7 7 7 7 8 7 7 7 7 7 7 7
gt;
gt; Is there a formula that would look at everything in this row and if it
gt; sees
gt; the same value it would display a quot;yesquot; and if not it would display a
gt; quot;noquot;.
gt; Since the example has an quot;8quot; in F2 then it would display a no.
gt;
gt; Thanks,
Thanks

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =IF(COUNTIF(A2:M2,A2)=13,quot;Yesquot;,quot;Noquot;)
gt;
gt; Biff
gt;
gt; quot;Crawdaddyquot; gt; wrote in message
gt; ...
gt; gt; if I have data in cells A2 through M2 is there a formula I could use to
gt; gt; identify and differences in the data.
gt; gt;
gt; gt; Ex.
gt; gt;
gt; gt; A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2
gt; gt; 7 7 7 7 7 8 7 7 7 7 7 7 7
gt; gt;
gt; gt; Is there a formula that would look at everything in this row and if it
gt; gt; sees
gt; gt; the same value it would display a quot;yesquot; and if not it would display a
gt; gt; quot;noquot;.
gt; gt; Since the example has an quot;8quot; in F2 then it would display a no.
gt; gt;
gt; gt; Thanks,
gt;
gt;
gt;

You're welcome.

Biff

quot;Crawdaddyquot; gt; wrote in message
...
gt; Thanks
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =IF(COUNTIF(A2:M2,A2)=13,quot;Yesquot;,quot;Noquot;)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Crawdaddyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; if I have data in cells A2 through M2 is there a formula I could use to
gt;gt; gt; identify and differences in the data.
gt;gt; gt;
gt;gt; gt; Ex.
gt;gt; gt;
gt;gt; gt; A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2
gt;gt; gt; 7 7 7 7 7 8 7 7 7 7 7 7 7
gt;gt; gt;
gt;gt; gt; Is there a formula that would look at everything in this row and if it
gt;gt; gt; sees
gt;gt; gt; the same value it would display a quot;yesquot; and if not it would display a
gt;gt; gt; quot;noquot;.
gt;gt; gt; Since the example has an quot;8quot; in F2 then it would display a no.
gt;gt; gt;
gt;gt; gt; Thanks,
gt;gt;
gt;gt;
gt;gt;