View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve C[_2_] Steve C[_2_] is offline
external usenet poster
 
Posts: 4
Default Compare data in 2 columns for unique values

Is there any way to identify if there are multiple Sal Grades in Col B for
the Job Titles in Col A below? Perhaps a true false statement in a separate
column if the Sal Grade doesn't match the one above it.

Col A Col B
Job Title Sal Grade
Clerk A3
Clerk A1
Cook A2
Cook A2
Nurse B5
Nurse B4