Forum Discussion

Ariela Daniels's avatar
Ariela Daniels
Copper Contributor
May 08, 2018

How to maintain formula/link as I reorder cells via sort?

Hello   I have searched for the answer to this problem but keep getting how to create a constant which is not exactly what I need. So am posting it as a question... hopefully someone can help :)  ...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 07, 2021

Ariela Daniels 

I'd add another column for calculations like

assuming you have two records per day and description is the same. Formula depends on your version of Excel, but this one shall work on all

=[@Sum]+
 IF([@Description]="Internet/Phone",
     0,
     70*0.9+(
         INDEX([Sum],
              MATCH(1,
              INDEX(([Date]=[@Date])*([Description]="Internet/Phone"),0),0) ) -
         70)*0.8
)

Resources