View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Determining if two columns values are equal/close

maybe

=OR(ISNUMBER(FIND(G25,H25)),ISNUMBER(FIND(H25,G25) ))

"GDCross" wrote:

I have two columns of data as seen below:

ColA ColB
1 Acme Acme Inc.
2 XYZ ABC
3 Seal Seals

I need to define in Col C whether or not data from col A and B are equal or
close to being equal by using a True/False result. For example, row 1 and 3
would be a match. However row 2 would not.