Count number of deliveries to same address on different days

Hi all,

I have the following data (data sample attached) and I'm trying to work out how many times we delivered to the same address on different days (there maybe multiple lines for the same delivery on the same day). I then need to work out how many of these deliveries were under 5kg which I should be able to do easily.

Any questions let me know...

Thanks in advance for you help.

deliveries.xlsx

you should CONCATENATE the address rows for full address and then try this array formula (see attached):

Formula:

Please Login or Register  to view this content.

Note: Array Formula should be entered/confirmed with [Ctrl] + [Shift] + [Enter] (or their corresponding equivalent keys on MAC).

Credits to the solution provided here.

Thank you very much jewelsharma.


Turns out i'm not as smart as i thought. Can you add additional constraints to this formula. e.g. under 5kg ?

Thanks again for the help.

Awesome jewelsharma! Thank you very much!