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?
=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)
