Notifications
Clear all
Topic starter
Hello,
I'm trying to get a count of how many different stores have received product. What would the distinct formula be for this? For example for "Store ID" I'd only want it to could 1 for 25-387. The next time it would be in the list I would want it to be 0.
Thanks for your help!
Posted : 09/10/2019 4:42 pm
Hi Cara
Try this.
In cell N2 enter
=IF(COUNTIFS($C$2:C2,C2)=1,1,0)
Drag down as many rows as needed.
Hope this helps.
Sunny
Posted : 09/10/2019 8:39 pm
