Originally Posted by
p45cal
How can ANY result be 0?!
My results are a distinct count of
container number for every
MAWB/MBL
This is a screenshot from my results; it looks like it's a 2.
2024-04-12_114254.jpg
Hi,
You are correct but I need to total (sum) column C so I can obtain a count of unique container numbers, if I use your version I get incorrect values.
I think I may have solved it myself here by using the below code
=IF(COUNTIFS(B:B, B2,C:C,C2)>1,IF(COUNTIFS(B:B,B2,C:C,C2)>1,IF(COUNTIFS($B$2:B2, B2, $C$2:C2,C2)=1,1,0),""), 1)
UPDATE!
Actually this fails on some lines, unless I do a 'SORT' on column B in Ascending order, then formula works across all lines.
Would be good to get this to work without the need to sort in ascending order each time though, any thoughts people?