View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chirs Chirs is offline
external usenet poster
 
Posts: 7
Default 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