Duplicate Items different Prices

Working with a healthcare related database where items are used across several departments. I need to identify where the price charged is different from other departments. Ideally, I would be able to have a check box or notate them in some where where I could then filter/group.

Example:
Item Department Price
123 ER $50
123 Clinic $50
123 Radiology $100

How could I flag Item numbers there is at least 1 with a different price?

Hope this makes sense.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.