I'm working on a project in PowePivot were I have a database with different roads and there average length in km.
The range in length goes from about 20 km to 230 km.
What I want is to sort these lengths into 5 groups;
0-50 km , 50-100 km, 100-150 km, 150-200 km and 200-250 km.
I have some Text ## values in a A1 and B1. And some text values in A2, A3, A4.
1. T ##
What I need a script which sorts the text values in their alphabetical order variations according to conditions given below...
:warning:PLEASE HELP ME WITH THIS!!!:warning:
I am being very detailed in this, so I hope there's no confusion...
I'm still a newbie, but I'm starting to get the hang of this though
writing macros is still hard.
I have a project which requires that I check over 50,000 rows of data
to make sure...