Hi all,
I have a large datasheet that is composed of 6 columns (A:G) and nearly 37000 rows. Data sets are collated into groups separated by one blank row.
In order to accurately anlayze the data, I need to sort all data groups only by the first row in each group.
Sorting that first row of each group will have three ascending criteria in the following order:
1. ColB,
2. ColF,
3. the order of the first word in red in ColD.
As per attached example, data groups from Sheet1 are sorted out in the required manner in Sheet2:
- the first group is sorted by ColB (value 2), ColF (value 4) and the order of the first string in red which is "we"; the fifth in order.
- the last group is sorted by ColB (value 8), ColF (value 5) and the order of the first string in red which is "think"; the fourth in order.
I really hope I could get some valuable assistance with this question
Many thanks in advance
T.
Bookmarks