Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare multiple cell values
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare multiple cell values
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. -- HTH... Jim Thomlinson "Chirs" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare multiple cell values
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. "Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "Chirs" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare multiple cell values
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 : 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. "Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "Chirs" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare multiple rows for duplicated values in individual columns | Excel Worksheet Functions | |||
Compare cell values | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
compare two cell values on different sheets | Excel Programming |