Hi All,

I have an excel problem that is driving me crazy trying to figure it out without doing the work manually. it's a two part problem and luckily I have already done the first part. I have a worksheet where I've got a formula that says wherever you duplicates, identify the first in the series as '1st' and everything else within those duplicate occurrences as 'Other dups'. However, there is a second condition that I can't figure which I need. I need to look within a series of duplicates and look in a specific column (not the duplicate column) and see if at any point within the group of duplicates that column contains a "Y". If it does, then I want to put "yes" in the cell next to the duplicate occurrence column.

Below is an example. As you can see, the 4th row in this series of duplicates contains a 'Y". I want to basically say if within a series of duplicates a "Y" exists, indicate this in cell X. I can't figure out how to tell excel to know what range is each series of duplicates. each group of duplicates could be any number of rows. In other words, the count of duplicate rows per duplicate group is dynamic.


Antioch Delta Fair Medical Offices Medical Office Campus CN55-01 N Dup 1st
Antioch Delta Fair Medical Offices Medical Office Campus CN55-02 N Dup Other Dups
Antioch Delta Fair Medical Offices Medical Office Campus CN55-03 N Dup Other Dups
Antioch Delta Fair Medical Offices Medical Office Campus CN55-04 Y Dup Other Dups
Antioch Delta Fair Medical Offices Medical Office Campus CN55-05 N Dup Other Dups
Antioch Delta Fair Medical Offices Medical Office Campus CN55-51 N Dup Other Dups
Antioch Delta Fair Medical Offices Medical Office Campus CN55-52 N Dup Other Dups