Trying to sort a Named range (three columns) by the third column and get column 1 and 2 as results alphabetically by column 2 and I am struggling.
Using Google sheets BTW if it matters
Trying to sort a Named range (three columns) by the third column and get column 1 and 2 as results alphabetically by column 2 and I am struggling.
Using Google sheets BTW if it matters
Last edited by Mrmeola; 01-03-2020 at 03:22 PM.
Found a Solution with helper cells, seems should be an easier way but I solved it.
Named the input range on left
used sort to pull data to another 3 columns
used filter to reorganize by team
used query to pull just the two columns of needed information into the proper team columns
for anyone else looking for something similar.
Formula:Please Login or Register to view this content.
Filter then sort didn't work so tried sort then filter... this produced the desired result without all the helper cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks