Thanks Whatsup - Works great! But how do I make the formula give me an empty cell if I copy the formula way below the last cell with ID so that the formula can capture new IDs as they are coming in without showing me No until it sees an ID.

Like saying If No IDs in any Cell B (B5) I get "empty" rather than No. Thanks!!