Have a large excel 2010 spreadsheet. I need to count the number of orders. Some orders are listed several times for difference reasons. Is there a way to use the count function so it doesn’t count duplicate entries?
Sample: (answer should be 4 orders)
A
1 2555
2 2555
3 2555
4 2556
5 2556
6 2557
7 2558
You can copy the order numbers to a blank column and use the Remove Duplicates option in excel. Then do a count on that column.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Try
=SUM(SIGN(FREQUENCY(A1:A7,A1:A7))) >> adjust ranges to suit and this is just for numeric
HTH
Regards, Jeff
Arlu1201, thanks!
Jefferybrown, the forumla worked great.
Glad to see you have a couple of options to work with and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks