Skip to Content
Former Member
Aug 12, 2015 at 07:55 PM

Need help with a formula - Distinct Count?



I need help with the following scenario. I need to know how many ship ID's for an item number there are in the same group. Look at Item# 105, it shipped twice on the same order with two different ShipID's, therefore the No of Ship ID's should be two. I'm pulling my hair trying to build this formula and I'm failing all the time.

Any help would be greatly appreciated.

Group: Order#1

ItemNumber Qty ShipID No of Ship ID's

105 5 1000 2

205 10 1000 1

105 7 1005 2