I hope you can help
I have a sheet that is completed by various personnel to detail packing requirements for shipments including weights, dimensions and stock information.
Basically, I would like to know if there is a way in which a formula can look at the carton number in column A and if it is the same as the next line entry, then the carton dimensions are not repeated until the carton number changes.
Ive tried this formula:-
But it gives me the same result ??
I have attached an example, if you could help I would be very grateful