View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tarbrook tarbrook is offline
external usenet poster
 
Posts: 2
Default Comparing value in multiple columns

Hello,
What is the best way to see if there are any differences in the values for
numerous colunms, excluding any blank cells? There are 24 columns, including
columns with blank values. Couldn't get if statement to work... Example:
IBLITM CA03 CA01 CA02 CA04
000000103 31 31 31 31
000000309 31 31 31 31
000000701 31 31 31 31
000000804 31 31 31 31
000001104 31 31 31 31