esProc Desktopesproc-desktop.hashnode.dev·Oct 30, 2024#85 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Continuous (Link Relative Ratio And YOY)Problem description & analysis: Here below is an annual and quarterly sales data table: Task: Now we want to calculate LRR and YOY (to calculate in cell D1). Solution: Use SPL XLL and the code is as follows: A 1\=E(‘A1:C21’) 2\=A1.(Sales-Sal...10 likes#Excel-tutorialAdd a thoughtful commentNo comments yetBe the first to start the conversation.
