I have a column of numbers which may be either positive or negative numbers. I need to be able to count the number of clusters of positive numbers in that column of numbers where the cluster is = to or greater than 3 consecutive positive numbers. Meaning, if 3,5, 18 occurs consecutively that is a cluster and is counted as 1, as would be 19, 59, 24, 83 counted as cluster 2 and so on. Any help would be appreciated.
Hello SEABOND,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
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]
@SEABOND, I think you wrote your post in a wrong place, you have to replace it to section Excel General. And also, It will be helpfull if you attach an excel file as an example of what you are trying to achieve
See your other thread...
https://www.excelforum.com/showthread.php?t=1149892
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks