![]() |
![]() |
![]() |
||||
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
![]() ![]() |
|
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
Thread Tools |
![]() |
#1 |
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
Is there a way to sort by keywords in Excel?
I need to sort or show only specific keywords in columns in excel. For example put all the the cells that contain the word "food" at the top. It is in the center or end of the description so can't sort by name.
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#2 |
Confirmed User
Join Date: Jan 2005
Posts: 6,478
|
this tool will organize your keywords in text files.
http://www.money-mining-tools.com/downloads/nko.zip |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#3 |
Confirmed User
Join Date: Jan 2005
Posts: 6,478
|
sorry that url is not working search for nichebot keyword organizer in google
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#4 |
Confirmed User
Join Date: Jan 2005
Posts: 6,478
|
ok found that tool
http://www.nichebotclassic.com/gift/appreciation.php |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#5 |
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
thanks but was looking for something free
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#6 |
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
bump, still need this, fucking excel
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#7 |
Confirmed User
Join Date: Dec 2003
Location: In Quarantine
Posts: 869
|
I couldn't find how to do it in Excel, but it is easy to do with the MS Works database, if your computer already has it installed.
Just copy your Excel cells and paste them into a new Works database, then do a 'find all' with your keyword. I'm sure you can also do it with MS Access, but it is a piece of cake with Works. |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#8 |
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
Does the find all results show up in database copy and paste format? Excel has find all too but the results aren't copy/filterable
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#9 |
Confirmed User
Join Date: Apr 2006
Posts: 1,735
|
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#10 |
Confirmed User
Join Date: Dec 2003
Location: In Quarantine
Posts: 869
|
Yeah, it will show only the records that have the keyword you searched for. You can then copy and paste the cells you select back into excel if you wish.
|
![]() |
![]() ![]() ![]() ![]() ![]() |