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!

##SOLUTION

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

2 Likes

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

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

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

1 Like

Awesome! Thanks so much for all your help guys.

Here is the solution I discovered:

SOLUTION:

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

Is this what you did @insomnijak ?

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

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

3 Likes

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