jmitchells5w
New Member
- Joined
- Jun 14, 2007
- Messages
- 35
I am trying to find a way to use a formula to compare text in a column labeled UOM (Unit of Measure) to see if all cells are the same. I have a list of purchases and the UOM should be the same but occcasionally they are different. e.g. purchase based on "EA" (eaches) instead of "/M" (thousands). This, of course, skews my sum formulas. These lists are created using sumproduct. Any ideas? Also, the UOM may be different depending on what is purchased. I don't care what the UOM is, it just needs to be the same. Thanks in advance for your help!!!