Forum Discussion

Odintsov_Maksim's avatar
Odintsov_Maksim
Copper Contributor
May 23, 2020
Solved

Large amount of data sorting

Please, help. Need to sort numeric data contained in large numbers (several thousand) strings. The data in each string must be sorted separately. How can this be done quickly.
BI & Data Analysis
Macros and VBA
  • Jos_Woolley's avatar
    Jos_Woolley
    May 26, 2020

    Odintsov_Maksim 

     

    Apologies. You're correct. Small adjustment needed: change

     

    If MyCol <> 1 Then

    to

    If MyCol > 2 Then

     

    Regards

     

     

Jos_Woolley's avatar
Jos_Woolley
Iron Contributor
May 26, 2020

Odintsov_Maksim 

 

Apologies. You're correct. Small adjustment needed: change

 

If MyCol <> 1 Then

to

If MyCol > 2 Then

 

Regards

 

 

  • Odintsov_Maksim's avatar
    Odintsov_Maksim
    Copper Contributor
    May 26, 2020
    OK, worked.
    Will be testing.
    Thank you so much!

Resources