Sorting data question

New Contributor

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!

2 Replies

@Bman62526 

If I understand your data arrangement, you could use:

=COUNTA(UNIQUE(Account))
Thank you - I will try that!