2024-08-07 11:48
Need help google SHEET/EXCEL expert yang biasa guna formula :
(Match-offset) - index.
i susun sheet macam ni :-
Sheet 1 - master.
Sheet 2,3,4- sub master by match index etc.
So data from master akan appear kat sub master. Sini yang guna match,offset - index.
Soalannya : Macam mana nak return balik data from sub to master? Sebab row dah lari since match ada kat sheet 2,3,4
Dah try reverse balik. Tak jadi sebab row dah ikut sheet 2,3,4.
Pening. Kalau perlu lukisan sila dm. 😂