Dec 05 2022 10:07 AM
I am hoping someone can assist with this data sorting question. I have an Excel worksheet containing a list of customer orders. There are 1700 lines in the worksheet. I have been tasked with providing the number of total orders, but most orders contain multiple lines per order so I cannot simply sum the total of the "order number" column. For instance, person A ordered 3 items so that order is 3 lines in my sheet. Person B ordered 6 items so that order created 6 lines. How can I sort by total number of individual orders, not total items ordered. I am using Windows 10, Excel Version 2210 Build 16.0.15726.20188. Thank you!
Dec 05 2022 11:46 AM