Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Excel help #666


Zoob

Recommended Posts

I have several thousand rows of data that contain numbers between 1 and 10 in columns A-J.

 

for each row, I need to flag where all the numbers in columns A-J are all the same (i.e. all 3, or all 10 etc...)

 

I'm sure there must be some way of doing this in Excel, but I can't work it out.

 

Any help would be greatly appreciated :)

 

Cheers...

Link to comment
Share on other sites

why?

 

 

 

oh and use pivot tables

 

I'm looking at survey data, and want to know if people were paying attention (most likely they were not)... The same data in each column means they gave contradictory answers.

 

Not sure how a pivot table would help though... thought it would be more like a VLOOKUP or IF formula, since I need to be able to flag individual records rather than look on aggregate..

Link to comment
Share on other sites

in column k1 put =if(max(a1:j1)=min(a1:j1);1;0))

 

this puts a 1 in each column K when they're all equal and a 0 when they're not

 

you might need a , instead of a ;

 

Awesome - thank you very very much :)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...