I want to be able to delete rows (green, blue, purple; but these will always change) and have the simple calculation (previous row minus one) recalculate. When I delete them I get a reference error. Is there another calculation that I could us?
(I tried downloading the add-in to put in an Excel image, but Colo’s site is not working)
red 1
orange 2
yellow 3
green 4
blue 5
purple 6
black 7
white 8
brown 9
what I want
red 1
orange 2
yellow 3
green (deleted)
blue (deleted)
purple (deleted)
black 4 (were REF error)
white 5 (were REF error)
brown 6 (were REF error)
(I tried downloading the add-in to put in an Excel image, but Colo’s site is not working)
red 1
orange 2
yellow 3
green 4
blue 5
purple 6
black 7
white 8
brown 9
what I want
red 1
orange 2
yellow 3
green (deleted)
blue (deleted)
purple (deleted)
black 4 (were REF error)
white 5 (were REF error)
brown 6 (were REF error)