Formula to Count from Mid-Range to Bottom

Cross-posted at https://www.mrexcel.com/board/thread...rmula.1205385/

I need to your help with a formula im trying to build and its been days I have tried my ways but I haven’t reached anywhere

I have attached a sheet which is sample file…below are the steps I take to update.

I filter the data by Month as I have 6 months data.
I filter it by unit as I have two unit
I have 8 different columns with 8 metrics.
1st select the first data column and sort is desc to asc.
I count the total day on that column.
For eg if its 50 then I need the top 30. Mid 40 and bottom 30
I multiply 50*30% give me m top30 and bottom 30 which is 15 each
Remaining 20 as my mid40 percent
I have to do this manually and assign the name on E Column for the first 15 entries as T30 then go on to other 20 and type M40 and remaining as B30.
Now I have data in thousands and it’s a very tedious task to do this everytime manually.
Is tehre a way to create a formula which takes count and cover the cells I need to my to mid and bottow.

Sample is given for you to refer

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time, however your description of what you are wanting help with is not clear to me, so you may need to add more detail to it yourself.)

In G2 (count of rows)

=LOOKUP(2,1/(D2:D1000),ROW(A2:A1000))-1

in F2

=IF(ROWS($1:1)<=INT($G$2*0.3),"T30",IF(ROWS($1:1)>=INT($G$2*0.7),"B30","M30"))

"
I have 32 counts
32*30% gives me 9.6 which become my top and bottom
9.6 Top 30
9.6 Bottom 30
19.2 becomes Mid 40
we can round it to 7 for top and bottom and 18 for Mid

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link for you since this is your first thread.