Forum Discussion
Working out when a regular subscription changed from transaction lists
We have around 2000 subscribers, who are paying various amounts for a few services. What we need to do is find out when they upgraded thier recent subscription. This should be when their payments inc...
=INDEX($D$2:$D$18,MATCH(1,($C$2:$C$18=G2)*($E$2:$E$18<>$E$3:$E$19),0)+1)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Can the new amount also be pulled back?