Hi,
Should be an easy one, I have a sheet with 64000 items of kit listed against a couple of hundred different contract numbers. Currently in the format:
contract1 kit1
contract1 kit2
contract1 kit3
contract1 kit4
contract2 kit5
contract2 kit6
contract3 kit7
contract3 kit8
contract3 kit9
i.e. this would be 3 contracts, with 4, 2 and 3 items of kit against them. So the question is, how do I count the contract numbers?
Any help would be much appreciated.
Cheers,
Marcus
Should be an easy one, I have a sheet with 64000 items of kit listed against a couple of hundred different contract numbers. Currently in the format:
contract1 kit1
contract1 kit2
contract1 kit3
contract1 kit4
contract2 kit5
contract2 kit6
contract3 kit7
contract3 kit8
contract3 kit9
i.e. this would be 3 contracts, with 4, 2 and 3 items of kit against them. So the question is, how do I count the contract numbers?
Any help would be much appreciated.
Cheers,
Marcus