Help Flag Rows When Certain Parameters Met

[helloworld123]

Grateful for any assistance regarding a dataset I'm working with.

Task: Cleasing an item dictionary and need to highlight an item # that will become the master # for all sites going forward.

Is there any formula that can flag whether the following parameters are true? Note, site a is the "default", site b would be "secondary default". Always looking at fields whenever they have the same v2key.
1) Given same unique v2. If item # at site a = item # at site b, flag that row. This is one is a simple if and statement I think but this doesn't occur often.
2) If item # at site a is different then b, then use the most common item # between all sites (a,b,c,d,e) for that particular v2key. So if one item # is at one site and 2/3/4/ sites has another same #, use the latter most common.
3) If all item #'s are different, then use site A if stocked = (Y) since its the first default, or site b if site a is not stocked (N), and site b is stocked (Y)

Below is a sample dataset, and given the above I would want rows 3,6,9,12,15,18 flagged (including column headers). Any suggestions on syntax or advice for what formulas to review in order to solve this problem? Thanks in advance!


V2KEY ITEM NUMBER SITE STOCK
62 4915112 b N
62 4915112 a N
62 4911001 c N
62 4915112 c N
209 2800002 b N
209 2802906 d N
209 2800002 c N
223 3509125 d N
223 5351270 a Y
223 3509125 c Y
251 2250027 a N
251 2250039 e Y
355 3503336 b Y
355 3503336 a N
355 3509764 c N
435 3859272 b Y
435 3859272 a Y
435 3859272 b N
435 3857806 c Y

[Special-K]

Take a look at Conditional Formatting

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[helloworld123]

Hi! Please see attached test dummy file