View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Validate data in a range is exactly the same for values in column

Can you elucidate a little on this:

compare cell differences on each column/row between
the first occurence of a value to subsequent occurences
of the same value.



"jonnybrovo815" wrote:

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.