Sep 30 2021 12:14 PM
Oct 01 2021 07:30 AM
@Tara_Simphson so you can create another column and use something like:
=COUNTIFS(A:A,A1,B:B,B1)
and fill down. Then any row with a value >1 has a duplicate. This is useful so can also easily find them and know how many duplicates of that value exist.
That said, I recommend not using A:A if possible. Ideally your data should be formatted as a table and then use table notation like:
=COUNTIFS([order number],[@[order number]],[id],[@id])
if you don't want that extra column and just the number and have excel365 then you could use something like
=ROWS(UNIQUE(B1:C100,FALSE,TRUE))
to count how many unique rows there are and divide by total number of rows or subtract from total number of rows or subtract and then divide depending on exactly what you want/need.
Oct 07 2021 01:56 AM
Oct 07 2021 02:46 AM
Where does the information in your worksheet come from, the packing slip? or shipping information?, and how can you tell from the packing slip or shipping information that the same lot number in the same order ended up in a different container. or do you get that information from the receiving people? then compare what they accounted for against what's on the paper work?