Hi all,
so, I've created a set of arrays (sheet 2) to filter, sort, and remove blanks from across two columns (first name, last name) of a larger data set (level 4) and I'm outputting the results into a single column sorted alphabetically by last name.
I have used a set of four helper columns in sheet 2 to achieve this, but at the point where I sort the filtered data from columns B and C into column D I find that if there are two unique records with the same last names, it will enter the first instance twice instead of once each for both.
I have made a sample spreadsheet here's a download link:
http://aubilltech.weebly.com/uploads/4/1/1/8/4118723/filter_and_sort_test.xlsx
Also, I have a unique record ID column that could come in handy in column A, but I'd prefer to avoid using even more helper columns.
so, I've created a set of arrays (sheet 2) to filter, sort, and remove blanks from across two columns (first name, last name) of a larger data set (level 4) and I'm outputting the results into a single column sorted alphabetically by last name.
I have used a set of four helper columns in sheet 2 to achieve this, but at the point where I sort the filtered data from columns B and C into column D I find that if there are two unique records with the same last names, it will enter the first instance twice instead of once each for both.
I have made a sample spreadsheet here's a download link:
http://aubilltech.weebly.com/uploads/4/1/1/8/4118723/filter_and_sort_test.xlsx
Also, I have a unique record ID column that could come in handy in column A, but I'd prefer to avoid using even more helper columns.