Snasui Excel Forum

Thanks i come up with FV

Thank you

Loan compounding it means include principal n interest for base of calculate interest
Mth 1:120,000 *13%÷12=1300 interest
Mth 2:121,300*13%÷12=1,304.08 interest
Mth 3:122,604.08*13%÷12=1,328.21
.....
So format
Date principal interest total

Dear all,

I need your input to create loan schedule
Loan amt:120,000$
Interest rate :13% per year
Repayment date
start 01/11/08
Maturity date:30/11/2025
repay monthly and principal add interest as new balance then calculate interest and so on
Note do not need dynamic array formula
Thanks

Dear all,
I need your input to transpose data as per attached.
The required outcome is in workbook

Thk

Dear all,
I need your input to find payback period for projects upon cumulative cash flow

Pls find the attached to refer to input n output

Thanks

Thanks

Dear all,
I need your input to build formula to arrange name by each department, dynamic array that produces output like in attach template

Thk

Thanks

Thanks

Dear all,

I need your input to solve this issue

Pls find the attached

Thanks

Dear all,

I need your input to find total by group whose total nearest
The data in column A,B n answer in the next
Pls find the attached

Thanks

Thanks you

Thanks you

I try it but no luck
=LET(
Data, B4:C28,
C,CHOOSECOLS,
D, C(Data,1),
S, C(Data,2),
Start, MIN(D),
WkNum, ROUNDUP((D - Start + 1) / 7, 0),
Wk, UNIQUE(WkNum),

WkStart, Start + (Wk - 1) * 7,
WkEnd, MIN(MAX(D), WkStart + 6),

Results, HSTACK(
TEXT(WkStart, "dd-mmm-yy") & " to " & TEXT ...

Yes your formula works awesome, i try it but no luck
=LET(
a, A2:A7,
GETVAL, LAMBDA(m, --TEXTBEFORE(TEXTAFTER(a, m), IF({1,0}, " ", CHAR(10)))),
Country, TEXTBEFORE(TEXTBEFORE(a, " (", 1), " "),
t, TEXTAFTER(TEXTBEFORE(TEXTAFTER(a, "("), ")"), " "),
LAT, GETVAL("LAT "),
LONG, GETVAL("LONG ...

Can be without MAKEARRAY? Thk

It both works.thk

Dear all ,

I need dynamic array to solve problem n get outputs as in attached


Thanks

I have a query 2,required dynamic array to transform data

I attach a template

Thk