RomanNaz
New Member
- Joined
- May 31, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
Hello! Trying to make sheet for import UPS shipments from SOR.
I have excel with orders and shipment data. 1 row = 1 shipping box
I need to find duplicates in column with order number, add count of duplicates to cell (e.g. "number of boxes"), then delete duplicate rows but keep one
Before:
Order Name Phone
1234 John 8909809
1234 John 8909809
1234 John 8909809
1248 Mike 9898799
1248 Mike 9898799
1248 Mike 9898799
1234 John 8909809
After:
Order Name Phone NumbrBoxes
1234 John 8909809 4
1248 Mike 9898799 3
I really appreciate any help you can provide
I have excel with orders and shipment data. 1 row = 1 shipping box
I need to find duplicates in column with order number, add count of duplicates to cell (e.g. "number of boxes"), then delete duplicate rows but keep one
Before:
Order Name Phone
1234 John 8909809
1234 John 8909809
1234 John 8909809
1248 Mike 9898799
1248 Mike 9898799
1248 Mike 9898799
1234 John 8909809
After:
Order Name Phone NumbrBoxes
1234 John 8909809 4
1248 Mike 9898799 3
I really appreciate any help you can provide