View Single Post
 
Old 04-30-2018, 08:16 AM
SailorJerry7030 SailorJerry7030 is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Apr 2018
Posts: 7
SailorJerry7030 is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Perhaps post a sample sheet with some data and expected results? ( Go advanced - Manage attachments)
No problem! Here is the test data. Test 1, Test 2, etc will be policy #'s and column Q is where I'd like the sum of the clusters to be placed. The Excel Code that ArviLaanemets provided works perfectly and gives the correct results in column S. However, I'm trying to use code in VBA to achieve these results as it will be for a larger data set.
Attached Images
File Type: png sample.PNG (16.2 KB, 13 views)
Reply With Quote