View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jonnybrovo815 jonnybrovo815 is offline
external usenet poster
 
Posts: 23
Default Validate data in a range is exactly the same for values in column

I want to identify duplicate values in column K. I then want to compare cell
differences on each column/row between the first occurence of a value to
subsequent occurences of the same value. I want to have a list showing what
the value was in row K, the row numbers they occur on, and what the
differences were on the subsequent rows. If there are no differences then I
don't want to know.

One note the range of cells on each row is constant.