1 Response to Find Inconsistent Document Tags with Excel

  1. Michael Dew says:

    I think you can also do it (perhaps more simply / quicky) by inserting a new column D (to the right of the “Resp.” column, typing the formula =+IF(AND(A2=A3,C2C3),1,””) into cell D3, and then copy that formula down column D. 1s will appear in all rows that have errors i.e. the formula places a 1 in column D if successive rows have family names that are the same but do not have successive “Resp.” codings that are the same.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s