Forum Discussion
kenhoegl
Oct 01, 2021Copper Contributor
Excel question 'deciling'
I am wondering if anyone can help me with an excel script.. I have a spreadsheet capturing a name (column A) and number (column B) in descending order from greatest to least these are blinde...
HansVogelaar
Oct 01, 2021MVP
In C2, enter the start value 10.
In C3, enter the formula
=C2-(SUM($B$2:$B3)>(11-C2)*$F$4)
Fill down to the last row with data.