View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric_NY Eric_NY is offline
external usenet poster
 
Posts: 58
Default Formula to check two rows for equivalence

In Excel 2003, I have a sheet with multiple columns of various different data
types (numeric, date, text, etc.). Is there a simple formula that can check
whether one row is equivalent to the next (i.e., A1 = A2, B1 = B2, . . . , M1
= M2)?

Thanks.