Make Numbers Ratain their Value Regardless of Subsequent Spreadsheet Procedures

[Bobaree]

One of the VBA calculations on my spreadsheet determines percentrank when compared to a column of company financial ratios. These percentranks are subsequently divided into deciles with the deciles being shown in another comumn.

The next step in my program is to delete the rows containing the 5 worst deciles. But, when I do that, the percentranks and therefore the deciles change. In other words, the remaining company ratios are re-ranked among themselves and the decile numbers change. Can these numbers be made to retain their original results, even as the procedures continue?

Thanks for any help on from the participants of this great forum.

 

[Andrew Poulsom]

You would need to convert your formulas to values (Copy|Paste Special|Values) before deleting the unwanted rows.

 

[Bobaree]

Thank you for that beautifully simple solution. It works.