Forum Discussion
Solved
Custom Excel List help!
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. ...
=ROW()&"C("&A1&")"
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.
=ROW()&"C("&A1&")"
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!