User Profile
micyano
Copper Contributor
Joined Nov 27, 2023
User Widgets
Recent Discussions
Sum the top x% of data
Hello friends, I have a dynamic table array that will display multiple columns and rows of data. I need a way to parse this data and only sum the top (say 20%, this number might change) of the data. Elsewhere on the sheet I have a total for the number of sections, as well as the height at the top. The number of rows in the table will change (AKA the number of sections is dynamic), as will the total height. Thanks for reading MichaelHow to generate a table of data built up off of smaller parts?
Hello Excel Gurus I can't even figure out how to ask this question so I'm hoping if you can look at the data set I'm working with, and how it should look after combining the information, someone can hopefully point me in the right direction. The first table (on the left) is my information. Column A is the name of range of data Column B is the bottom of the range - the bottom of each section is equal to the top of the section below [AKA the bottom of "B" is the top of "A"], there will never be a gap and "A" will always start at 0 (Although the names will vary, sometimes being the same name as another section) Column C is the top of the range Column D is the length of each portion Column E is how many portions make up each section. The second table (on the right) is what I need generated Column G is the name from where the portion is from Column H is the bottom of the portion Column I is the top of the portion I don't know what the final size of the Table A, so Table B needs to be able to grow dynamically. Is this doable, or will I need to do this by hand for every set of data? Thanks in Advance Michael
