#### PivotMeThis

##### Active Member

- Joined
- Jun 24, 2002

- Messages
- 346

I have two columns that contain duplicates. One column (K) contains Project Numbers and the other column (X) contains Item Numbers. I need a formula that will return a 1 or a 0.

If the project number and the item number are listed together once, then the formula should return a 1 but if the project number and the item number are listed together more than once, the other entries should show a 0.