Hi Guys,
Is there a way to do the following. I basically want to Use the first name from Column C (Name) and populate Column D (Name 2) if the ref in column A is identical to the cell above or below and if column B shows yes. I hope this makes sense. So the formula in column D would look like...