NMT
New member
- Joined
- Aug 20, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Version 2107
Hi all! Would appreciate help on writing a sorting algorithm using Excel VBA. I have a data file. Each row is a question. Each column corresponds to a survey I have. If the cell (i,j) has a question number, it means the question has been used for that survey. However, the type of question numbers differ for types of surveys.
For example:
Type A survey typically has question labels running from 1-20, followed by S1-S18. It's a mix of numbers and alphanumeric characters.
Type B survey typically has question labels running from A1-A5, B1-B5 and sometimes with label like A1a, A1b...
So there is great mix of question labels. I hope to sort the labels in the following way so that questions appear in the right order:
1
1a
1b
1c
2
2a
2b
2(1)
2(2)
3
5
6
10
12
A1
A1a
A1(1)
A2
A4
A10
A11
B1
B2a
B2(2)
and so on...
Is it possible to write an algorithm for the above given that it seems rather complex conditions? Is it practical to sort it using excel VBA?
For example:
Type A survey typically has question labels running from 1-20, followed by S1-S18. It's a mix of numbers and alphanumeric characters.
Type B survey typically has question labels running from A1-A5, B1-B5 and sometimes with label like A1a, A1b...
So there is great mix of question labels. I hope to sort the labels in the following way so that questions appear in the right order:
1
1a
1b
1c
2
2a
2b
2(1)
2(2)
3
5
6
10
12
A1
A1a
A1(1)
A2
A4
A10
A11
B1
B2a
B2(2)
and so on...
Is it possible to write an algorithm for the above given that it seems rather complex conditions? Is it practical to sort it using excel VBA?