[SOLVED] Help With Excel (Google Sheets) Formula to organize data

Hey Guys,

I am working on an excel sheet which will categorize hashtags for specific niches into 6 categories of popularity (post count)

Category #1 - 0k-100k
Category #2 - 100k-500k
Category #4 - 500k-1000k
Category #5 - 1m-10m
Category #6 - 10m-100m
Category #7 - 100m+

Now I need help trying to format each column so the hashtags are displayed in the order of least to greatest.

For example in Category #1 0k-100k, I have 3 hashtags:
Hashtag #1 76k (Medium)
Hashtag #2 44k (Smallest)
Hashtag #3 89k (Largest)

I would like a formula to automatically sort these 3 hashtags from least to greatest like so:
Hashtag #2 44k (Smallest)
Hashtag #1 76k (Medium)
Hashtag #3 89k (Largest)

Can any of you help me with this formula. The only one I know only sorts the numbers. When the numbers move, the associated hashtag does not move (not good)

In other words Column A has the hashtag name & Column B has the post count. I need to sort the post counts from least to greatest but both Column A and B need to move with each other.

Thanks to anyone who can help!


  1. Select both ColumnA (hashtags) & ColumnB (post count)
  2. Right click and select Sort Range
  3. Sort By: The column that contains the post count (Column B in my case)
  4. Select: A-Z

having multiple rows like (ab) and (cd) next to each other doesn’t help at all, would having several multiple files for different numbers be bad? like 1 file with 2 rows for 0-100 and other file for 100-1k :sweat_smile:
for this task i am using libreoffice (free excel alternative ) i have highlighted the arrows to sort the rows

1 Like

Awesome thanks @mindeswx for your quick and helpful reply.

Since I have no better method, yours wins so far :slight_smile:

I would prefer to have them all in one document with multiple pages for each niche:

Page #1 - Niche #1 - All Categories
Page #2 - Niche #2 - All Categories
Page #3 - Niche #3 - All Categories

However, I can use your method on a new document, and once organized I can copy and paste them back into my main document.

Would you possible know how to do this without creating a new document for each category?

1 Like

you can actually do this in a same file if you really need it , yet i thought it’s easier to work with 2 rows,
however if you need to work with many rows in 1 file you can sort them, just select like this http://dl4.joxi.net/drive/2017/02/11/0021/0072/1425480/80/2cfc85a0e0.jpg
important part is to select the numbers row first (if you would select hastags row it would sort in alphabetical order )

1 Like

Oh sweet I managed to do it in Google Sheets by right clicking, and selecting Sort Range.

The problem now is I cant repeat the proceeds for some reason haha.

yep, that works too, i know nothing about google sheets :grinning:

1 Like

fixed it for you :slight_smile:

1 Like

Awesome! Thanks so much for all your help guys.

Here is the solution I discovered:


  1. Select both the hashtags & post count
  2. Right click and select Sort Range
  3. Sort By: The column that contains the post count
  4. Select: A-Z

Is this what you did @insomnijak ?

egjactly :slight_smile:

1 Like

Awesome! I was doing this before with no luck. Anyways! I am so happy I have this working now! Back to work I go creating my MEGA hashtag list sorted by popularity :).

Let us know if you are stuck somewhere, there are some of us who earn their living with excel :slight_smile:

1 Like

Oh perfect! I have been using excel more and more through the years. I will for sure be needing more help in the future.

I usually just good how to do it, but I did not know the right terms to google for this specific problem.

Thanks @insomnijak and @mindeswx


Would it be possible to create a formula wherein hashtag number of post automatically update, instead of manually updating all of it?