+ Reply to Thread
Results 1 to 2 of 2

How to Sort Columns by Left-to-Right by WORD count

Hybrid View

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2011
    Posts
    1

    How to Sort Columns by Left-to-Right by WORD count

    Hi all! Big fan of the forum, hope I can get a little assist on this pesky problem.

    So I have a sheet with 200 URLs in column A. Each URL has 5-20 "keywords" in the columns next to it.

    From an SEO standpoint, often times I'd like to utilize keywords with the MOST word count "design courses online" vs. just "design"

    I've frozen column A. Is it possible for EACH row to be sorted where the cell w/ the most words in that row is first (column B) then it's sorted by descending order after that?

    I've tried several workarounds/transposing setups, but I can't get it down.

    Anybody know how to sort this doc so that keyword cells are arranged by word count for each URL?

    here are several screenshots of my embarrassing performance thus far:

    transposed: http://screencast.com/t/7HGSLOfepy
    raw: http://screencast.com/t/XJNqJLQ1RnxM
    word count under it: http://screencast.com/t/zEcXpVzv

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How to Sort Columns by Left-to-Right by WORD count

    Instead of screenshots, its good if you upload sample excel files. It will help all of us help you.

    You can try this. In a far-away column, put this formula =counta(A2:Z2) (considering that you have 25 keywords)

    Then sort the entire data set including this column, by using the formula column as your main field for the sort. Delete the formula column (or hide it).

    Thats it.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1