Hello everyone, I am Bikram from India. I am a newbie and recently started learning macros. I am looking forward to learn and contribute to the forum. Thanks.
Dear SirJB7,
Thank you for your quick response. I appreciate it. Yes, my data has several thousands of columns and I need to sort on numbers only.
Bikram
Dear Narayan,
Thank you for your prompt response. Please find below the link to my sample data. Please note that the number of columns are more than 1000. I want the data to be sorted on the numbers. The cell having the highest number remains at the top...
I need to sort alphanumeric data. The sorting has to be based on the numbers irrespective of the alphabets.
Current format and order:
2 = GHNB
1 = XGV
8 = ADKH
5 = MNJSDV
Required order
8 = ADKH
5 = MNJSDV
2 = GHNB
1 = XGV
Please note that I have 1000s of columns of data and need...