So I'm trying to get a formula that counts only unique values based on 2 columns. If you see the attached image as an example, I want the formula to tell me that Order 55370 counts as having Base# KH-1525HR only 1. Though that part has several line items on that order (Job#s) I only want it to tell me that this individual order ordered that base # once. Does this make sense?

Capture.JPG