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
Solved! Go to 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!
Hi @kayers
Thanks for the solution, it's working perfectly!