Is there a formula to directly calculate the minimum sum without borrowing auxiliary columns ?
Auxiliary columns D2:E5
E7 final result directly calculate
Any help would be appreciated! TQ
Is there a formula to directly calculate the minimum sum without borrowing auxiliary columns ?
Auxiliary columns D2:E5
E7 final result directly calculate
Any help would be appreciated! TQ
Last edited by rayhen; 05-30-2021 at 11:02 AM.
Deleted by JT
Last edited by JohnTopley; 05-30-2021 at 05:08 AM.
Please try
=SUM(MOD(SMALL(IF(TRANSPOSE(A2:A8)=A2:A8,TRANSPOSE(B2:B8),10^6)+ROW(A2:A8)*10^6,(ROW(A2:A8)-ROW(A2))*ROWS(A2:A8)+1)*(MATCH(A2:A8,A2:A8,)=ROW(A2:A8)-ROW(A1)),10^6))
Ctrl+Shift+Enter
and easier with MS365
=SUM(MINIFS(B2:B8,A2:A8,UNIQUE(A2:A8)))
post deleted
Last edited by kvsrinivasamurthy; 05-30-2021 at 09:39 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
E7 cell array formula
HTML Code:
@Bo_Ry and @wk9128
Excellent solution. Thank you both, thank you very much for the solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks