Hi all,
I have a long list of grant data (~450 entries), and every row represents one grants. There are two main kinds: GOS & project, and each entry is coded with the organization name (Column: Organization Name), and one of those two codes (Column: Grant Type).
I want to remove duplicates--but partially. Essentially, for every organization, I want to remove all duplicate GOS grants, but preserve all project grants. Right now, I can't figure out how to do that, because when I use the Remove Duplicates tool, it won't let me check Grant Type AND ADD IF . . .
So, is there a way to "Remove Duplicates if . . ."? I'd greatly appreciate knowing how!
Thanks,
Ben
I have a long list of grant data (~450 entries), and every row represents one grants. There are two main kinds: GOS & project, and each entry is coded with the organization name (Column: Organization Name), and one of those two codes (Column: Grant Type).
I want to remove duplicates--but partially. Essentially, for every organization, I want to remove all duplicate GOS grants, but preserve all project grants. Right now, I can't figure out how to do that, because when I use the Remove Duplicates tool, it won't let me check Grant Type AND ADD IF . . .
So, is there a way to "Remove Duplicates if . . ."? I'd greatly appreciate knowing how!
Thanks,
Ben
