Need a formula to deal with repeating values in a column

justme101

Board Regular
Joined
Nov 18, 2017
Messages
67
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have data in column BY which has multiple values across rows. Many of these values might repeat themselves, 2, 3, 4....no limit to how many times. There are values in column F, which have the either of the two markings "E" or "F".

My requirements is to go through column BY, look for repeating values, and if even any one of those repeating values have the marking F for them, then all these repeating values should get the words "YES" written beside them in column BZ else, they should have "NO".

For e.g. if the value XYZ repeats in column BY at rows 2,3 & 4, and column F, row 3 has a marking "F" and the other two rows have the markings "E", all three of these rows should have the words "YES" in column BZ. Any formula or VBA macro which can help me out with this is greatly appreciated, as I have been at it for quite some time now but not getting a solution. Thank you in advance.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Try:

Dante Amor
FBYBZ
1Eitm1YES
2Eitm1YES
3Eitm1YES
4Fitm1YES
5Eitm1YES
6Eitem2NO
7Eitem2NO
8Fitem3YES
Hoja1
Cell Formulas
RangeFormula
BZ1:BZ8BZ1=IF(COUNTIFS(F:F,"F",BY:BY,BY1),"YES","NO")
 
Upvote 0
Solution

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top