Data comparsion in column

[ItalianPlatinum]

Hello,
So I have sort of a 2 prong question. Summary I have a LARGE file with over 100 columns and many rows. The below is what I am trying to do in 2 waves.

1. Are there any differences in a column. For example do they all say A in them or do some also say B. The size of the file makes it cumbersome on what i thought were workarounds.
2. If I set a standard so all data in this column should be A; then a trigger will tell me these rows for this column don't fit your criteria.

Thanks in advance!

 

[abiblequestion]

I would use a vlookup or Match formula to comparte the two collums.
for the match you can use =A2=b2 (or critiera) if no match then the output is false otherwise the output will be true.

 

[Joe4]

If I set a standard so all data in this column should be A; then a trigger will tell me these rows for this column don't fit your criteria.

One simple way would be to use Conditional Formatting to highlight all the cells that do not meet your criteria.
For example, if the value you want to match to is in cell C1, and you want to check all the values in column A, then just highlight column A and use the following Conditional Formatting formula:

=AND(A1<>"",A1<>$C$1)

and choose your formatting color.

 

[ItalianPlatinum]

Ok so as I think about this that could replace my first step. if I want my standard to be X and they all say Y then I would want something to alert me. I will test this and comment back thank you!

 

[ItalianPlatinum]

Is there a way to pull that into a new tab called variances? for easy review. Just because the file is so large with many rows and columns.

 

[Joe4]

Is there a way to pull that into a new tab called variances? for easy review. Just because the file is so large with many rows and columns.

I would recommend changing your approach then, and going with Advanced Filters.
See the "Extract Data to Another Worksheet" section here: http://www.contextures.com/xladvfilter01.html