Hey folks, I can usually either figure something out or find an example online that works or almost works and incorporate it into what I need to do. Not this time though. Can anyone help me out here?
I have four columns of data. In column A, there is a size designation that could be one of any different 12 sizes.
Column B contains a length that could be any given length and is displayed with a (4) place decimal.
Column B could also contain duplicates of any or all lengths in any or all of the 12 sizes.
Column C is column B rounded to the nearest half inch.
Column D is populated with the number 1 used as a counter .
In columns E and F I use the Consolidate Command to consolidate the data by using columns C and D placing the length in column E and the consolidated quantity in column F.
This works great until I wish to include the data in column A. It is possible to have lengths that are the same except for the initial size. I need these to be totaled up by size rather than length.
The information in Columns A and B is sent to Excel from a AutoLisp program in AutoCAD and could be as little as (2) rows or as many as 100 plus.
I have included an example. (example.xls)(Note: The example contains (9) entries. Reality is infinite)
The Rounded Length column is the formula: =mround(B3,0.50)
Counter Column is the formula: =IF(B3 >1,1," ")