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...
Can the new amount also be pulled back?
=INDEX($E$2:$E$18,MATCH(1,($C$2:$C$18=G2)*($E$2:$E$18<>$E$3:$E$19),0)+1)Yes that's possible with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
- Thanks you for your really fast reply - I now have two solutions that work, thanks to the MS community. I fear however when I throw in some live data there might be some annomilies. (like if a person increase the subsciption level, but reduces the Number of subsruiptions. ie Was paying £40 (20X2) and changed to £22 (22x1)