martinblake02
New Member
- Joined
- Jan 13, 2016
- Messages
- 23
type | amount |
flour | 1g |
four | 2g |
rice | 5g |
veg | 2g |
meat | 1g |
<tbody>
</tbody>
hello,
I am still new to this forum and hope im asking in the right place.
I have a table with duplicate in column B, and values In column a.
I want to calculate how many duplicates I have in column b If column a = 1 or 2 (two options)
example is above.
so if told my formula that a could be flour or meat, the result would be 1 duplicate (1g)
therefore I need a formula like below, but I cant get anything to work:
if column a = "flour" or "meat" , count of duplicates = 1