Custom Excel List help!

New Contributor

Excel version 2109

I'm trying to create a custom list. It consists of two columns.

The first column (column a) is just numbers but they are not ascending or descending, they're in a custom order.

I need the second column (column B) to correspond to column A. Column B in descending order "1C, 2C, 3C" along with the column A number in brackets. See image below.

Is there any way to create a formula to complete this? It's super long to do manually.





2 Replies
best response confirmed by BCBrooke (New Contributor)




Enter above formula in B1 and copy down.

I understand you want 1C, 2C, 3C and so on in column B in ascending order according to your example.


Thank you!! This saved me so much time!