Formula Question

C

Crawdaddy

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 "yes" and if not it would display a "no".
Since the example has an "8" in F2 then it would display a no.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dividing after a long formula 5
Formatting a spreadsheet to calculate difference in dates etc. 2
Would like to input 3 letters into a cell, each having a different numerical value 5
Date Formula 85 factor 7
Delete Rows based on condition 2
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Aging Report 7
Calc staff vacation time based on more than 1 criteria 0

Top