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

Need help with a formula - Distinct Count?

19 Views

Hello,

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