How do I flag a record where certain criteria are met on other rows?

AnnaKisting

In my project, I have two record ID numbers – Main Record and Sub record. For every groups of Main Records, there should always be a sub record where the number matches the main record. If a group of main records doesn’t have a sub record with an ID that matches the Main record, I want it flagged. 

In the example below Main Record 123456 has a subrecord of 123456 – so everything is great.

Main Record 98765 does not have a Subrecord of 98765 so I need that one marked. 

mkoch

In column 4 (Flag Record) add an IF statement to compare the main record to the subrecord. Next add a conditional statement that monitors the flag column being 1. Then hide the flag record column.

AnnaKisting

No, I'm trying to create the goal column.

I need to be able to distinguish between rows Main records that have a sub record that matches the main record and those that do not.

Paul Newcome

Try something like this instead:

=IF(COUNTIFS([Sub Record]:[Sub Record], @cell = [Main Record]@row)> 0, "Standard Included", "No Standard")