Distribution based on criteria

DianChris

New Member
Joined
Sep 29, 2020
Messages
5
Office Version
  1. 2013
Platform
  1. Windows
Hello ,
I have data like this
DATEUNITHMTOTAL HM
21-11-20FD 11010
21-11-20FD 27.515
21-11-20FD 27.5-
21-11-20FD 355
21-11-20FD 477
22-11-20FD 1612
22-11-20FD 16-
22-11-20FD 338
22-11-20FD 33-
22-11-20FD 32-


The HM column should use the formula,.
formula how to produce as in the table ?

thank you
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Could you please explain the correlation between the value you expect HM to produce and the other data?
 
Upvote 0
Column E=UNIT
Column F=HM
Last Row=15
ARRAY Formula in G2 then copied down

=IFERROR(IF(E2=E1,"",SUM(F2:INDEX(F2:$F$16,MATCH(FALSE,E2:$E$16=E2,0)-1))),"")

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.
 
Last edited:
Upvote 0
Another option
+Fluff v2.xlsm
ABCD
1DATEUNITHMTOTAL HM
221/11/2020FD 11010
321/11/2020FD 27.515
421/11/2020FD 27.5 
521/11/2020FD 355
621/11/2020FD 477
722/11/2020FD 1612
822/11/2020FD 16 
922/11/2020FD 338
1022/11/2020FD 33 
1122/11/2020FD 32 
Master
Cell Formulas
RangeFormula
D2:D11D2=IF(B2=B1,"",SUMIFS(C:C,A:A,A2,B:B,B2))
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top