Dear all,
I'm anlaysing a large worksheet which contains nearly 80K or rows and extends over 26 columns (A:Z). Data sets are separated by one empty row, and vary in their number of rows, where the least set is just one row of data.
I need to sort all data sets across all columns according to their FIRST cell ONLY of ColJ, and highlight that first cell in red font for further analysis.
I have attached a made-up example which illustrates the question, where Sheet1 contains data sample before sorting, and Sheet2 contains data sets after sorting and highlighting ColJ each set's first cell in red font.
I do hope I can get some precious assistance with this question, please.
Many thanks in advance.
T.
Bookmarks