How to compare multiple cell values

[Guest]

I would like to know if there is a functionality that would let you compare
multiple cell values and indicate when a cell value is dissimilar. basically
i want to look at all the cells in a each column, if all the row values for a
given column are the same value then i want to hide the column, but if any of
the values are dissimilar then leave the column. the row count may change fom
sheet to sheet. thx for any assistance

 

[Guest]

This can be done with a fairly simple formula something like..

=IF(AND(A1=B1,B1=C1,C1=D1,D1=E1,E1=F1,F1=G1,G1=H1), 0, 1)

This formula compares a row from Columns A through H and flags dissimilar
values with a 1. You can then just filter on this new column. Instead of 0
and 1 you can use true and false or some other flags if you want. The nice
part about this way is you can filter and unfilter whenever you want.

 

[Guest]

Let me clarify, i need something to compare values in the same column not
across columns, als0oi dont want a cell formula i need something that can be
used in code with variables.

 

[keepITcool]

I posted a routine today in thread
"Comparing Formulas between Worksheets"
that may be of use.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Chirs wrote :