Finding an ID and also counting it

[dlopez]

Hi I'm trying to create two fields: 

1. Trying to find an ID from first column in second column in my table, although not all ID's will be in the second column 

2. If that ID is in that second column, then I'd like to return the count of times it shows up

Example is below

ID	Parent ID	Does the ID exist in Parent ID?	If so, how many?
12345	23456	False
23456	47851	True	3
34567	23456	False
45678	45874	False
64859	23456	False
16489	45874	False
47851	45874	True	2
15678	47851	True	1
45874	15678	True	3

Any help would be greatly appreciated. 

Cheers

[kelsey_kincaid · Accepted solution]

Hi @dlopez ,

A summarize & find/replace tool should get you what you need. I included an example below and attached. Let me know if you have any questions!

[dlopez · Accepted solution]

Hi @kayers

Thanks for the solution, it's working perfectly!