call us today: 1.800.876.8376
email us: info@synergy.com
Invert formula – The following formula can be used to invert the data in c0 and place it in c1.

c1 = cell(n – index(), 0)

where n is the last row number in the data window. Any empty rows at the bottom of the original data will be placed at the top of the output column. These can be selected and deleted.


Mark as helpful.
0

Posted in: Formula Entry: Advanced formulas