My previous post with same question was difficult to read
VBA code to calculate Unique Count OF COL1 if the value in COL2 is greater than zero
COL1 COL2
mary -230 Not to be counted <=0
john 8
bill 0 Not to be counted<=0
tef 550
lee -33 Not to be counted<=0
sam 560
joe 645
gert -10 Not to be counted<=0
lee 55
sam 35 Duplicate
The count is 5
Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
Thread Closed.
https://www.excelforum.com/excel-pro...que-count.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks