揾到了
Rachel Siegel
https://www.washingtonpost.com/people/rachel-siegel/
https://twitter.com/rachsieg/status/1473681572477952001/photo/1
https://twitter.com/rachsieg
=let(CurrentRate,B1,RateList,A3:A16,DotPlot,B3:B16,hike,sumif(RateList,">" & CurrentRate,DotPlot),maintain,sumif(RateList,"=" & CurrentRate,DotPlot),cut,sumif(RateList,"<" & CurrentRate,DotPlot),VSTACK(HSTACK("Hike",hike),HSTACK("Maintain",maintain),HSTACK("Cut",cut)))
=let(CurrentRate,H1,RateList,G4:G17,LastDotPlot,H4:H17,ThisDotPlot,I4:I17,LastHike,sumif(RateList,">" & CurrentRate,LastDotPlot),ThisHike,sumif(RateList,">" & CurrentRate,ThisDotPlot),LastMaintain,sumif(RateList,"=" & CurrentRate,LastDotPlot),ThisMaintain,sumif(RateList,"=" & CurrentRate,ThisDotPlot),LastCut,sumif(RateList,"<" & CurrentRate,LastDotPlot),ThisCut,sumif(RateList,"<" & CurrentRate,ThisDotPlot),VSTACK(HSTACK("","Last Meeting","This Meeting","Change"),HSTACK("Hike",LastHike,ThisHike,ThisHike-LastHike),HSTACK("Maintain",LastMaintain,ThisMaintain,ThisMaintain-LastMaintain),HSTACK("Cut",LastCut,ThisCut,ThisCut-LastCut)))