Google Sheets Ranking Hack You NEED to Know! TEXTJOIN + SORT + TOCOL - Excel Tips and Tricks

Google Sheets Ranking Hack You NEED to Know! TEXTJOIN + SORT + TOCOL.

Here's a formula feature in my video.

=TEXTJOIN(", ",TRUE,SORT(TOCOL(F5:H5),TOCOL(C5:E5),0))

The formula =TEXTJOIN(", ",TRUE,SORT(TOCOL(F5:H5),TOCOL(C5:E5),0)) combines values from ranges F5:H5 and C5:E5 into a single, comma-separated string. First, TOCOL(F5:H5) and TOCOL(C5:E5) convert the respective ranges into single-column arrays, ensuring uniform handling of the data. The SORT function then sorts the values from F5:H5 in descending order (indicated by the 0) based on the corresponding values in C5:E5, acting as sorting keys. Finally, TEXTJOIN merges the sorted values into one string, separated by commas (", "), with the TRUE argument ignoring any empty cells in the ranges. This results in a neatly formatted, sorted list of values from F5:H5, prioritized by the values in C5:E5.


#excel #tips #shorts #fyp