Software

Ask Software Development Questions and Get Answers ASAp

Ask a Computer Expert,
Get an Answer ASAP!

Software
This answer was rated:

I need help with instructions on how to enter a command in

Hi, I need help with...
Hi, I need help with instructions on how to enter a command in excel to search all rows that contain any of 8 words and highlight the row or remove the row. Is that possible? thanks
Show More
Show Less
Ask Your Own Software Question
Answered in 4 minutes by:
11/17/2017
Specialist Sean S.
Specialist Sean S., Computer Support Specialist
Category: Software
Satisfied Customers: 1,127
Experience: 5+ years IT experience. A+, Net+, Security+ certified
Verified

Good afternoon/evening!...My name is ***** ***** I look forward to helping you. Is there anything else to know other than remove any 8 specific words?

Ask Your Own Software Question
Customer reply replied 29 days ago
I actually need it to highlight or remove the entire row if any of the rows have any one of eight words

Okay. Do you want me to find a general command or do you want to give me those words and I can help construct the command. I would usually go about this by sorting the Excel document if any of those words meet the criteria and then highlighting them and deleting them. What are your thoughts?

Ask Your Own Software Question
Customer reply replied 29 days ago
Sure, actually just sorting them by the words would be better. Then I can cut and paste them to a different sheet. Then I would just need help sorting back. It is a list of people with the person's registration number, First, Middle Intl, Last, the year they were admitted to law school, The law school they went to, and then living or deceased. I would like to separate the 8 Ivy League schools - Brown, Columbia, Cornell, Dartmouth, Harvard, the University of Pennsylvania, Princeton, and Yale
Customer reply replied 29 days ago
I would like to separate all rows that contain any of those schools. It is currently sorted by last name

Okay. You wouldn't want a command then. You'll want to highlight the entire workbook, then Conditional formatting, then Highlight Cell Rules, then Text that Contains, then enter those words, and all the matches will be highlighted. Then you can sort them based on that matching color as well and copy, cut, etc.

Ask Your Own Software Question

Does that make sense?

Ask Your Own Software Question
Customer reply replied 29 days ago
Do you mind if I ask a few more questions though? It's been a very long time since I have used excel..
Customer reply replied 29 days ago
for example I don't even know how to "select all"

Sure. Also too, if you find it appropriate to help you, we have a remote connection option where I can show you these things too if it makes it easier, but feel free to use this chat as long as you'd like

Ask Your Own Software Question
Customer reply replied 29 days ago
I saw that but it is confidential info so I wouldn't be able to.

No problem. I completely understand. So you basically want to highlight the entire workbook or cells that have text in it. That is "select all"

Ask Your Own Software Question
Customer reply replied 29 days ago
For text that contains - do I have to do it seperately for each word? It stops selecting after I put a second word in. I tried separating by space and by comma

No, Once you select all the words/rows, then on the HOME tab, you should see CONDITIONAL FORMATTING on the middle of the ribbon. Do you see that?

Ask Your Own Software Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Software
Satisfied Customers: 2,050
Experience: 20 years experience providing remote computer support
Verified

HI i was working with you on this question, will be helping you from here

Ask Your Own Software Question

not sure why but for some reason you closed the other question, and I was unable to respond

Ask Your Own Software Question

can you send an example sheet, you can just make up a bunch of fake data to show what you want to accomplish

Ask Your Own Software Question
Customer reply replied 29 days ago
wow, that's annoying. I was in the middle of following the instructions that the other tech was giving me and was almost done. The other question was closed because I sat for close to an hour waiting for a response after you said "one Momemt"

Hi, I'm still here. I apologize about that. I will look into it to ensure it gets addressed. Would you like to continue working with me on this? Also, please note that negative rating will go to me and not the expert that joined that chat a few moments ago

Ask Your Own Software Question
Customer reply replied 29 days ago
Yeah, if we could finish that would be great. The other guy accepted my question originally and then didn't respond, that's what the negative was for. If you know how I can fix it, I will definitely do it.

Sure. i'm here now and will be happy to continue. I apologize for any inconvenience

Ask Your Own Software Question

Once we're done, if you can re-rate the question, that would negate the negative rating on this one which will affect me and not the other expert. Where did we leave off at?

Ask Your Own Software Question
Customer reply replied 29 days ago
ok sure. I am doing the conditional formating and entering the "text that contains", with each word seperately. Doesn't seem to work otherwise. And the file has some of the colleges listed or abreviated differently so Im getting them all added

Okay. Are you able to see where CONDITIONAL FORMATTING is on the HOME tab in the middle of the ribbon?

Ask Your Own Software Question
Customer reply replied 29 days ago
I have gone there and then I selected Highlight Cell Rules, then Text that contains, and I have all of the cells with those words highlighted now. Would I sort the rows now?

Yes. We're at that step now. Great! What's the next thing you need from me for this?

Specialist Sean S.
Specialist Sean S., Computer Support Specialist
Category: Software
Satisfied Customers: 1,127
Experience: 5+ years IT experience. A+, Net+, Security+ certified
Verified
Specialist Sean S. and 87 other Software Specialists are ready to help you
Ask your own question now
Customer reply replied 29 days ago
How do I sort the rows with the highlighted cells?
Customer reply replied 29 days ago
I actually just figured it out. Thank you very much for your help. I appreciate it.

You're very welcome. If you would like to request me directly anytime in the future, here the link to do so. I'll get an e-mail if I'm off-line https://www.justanswer.com/computer/expert-ssaunders/?rpt=3800

Ask Your Own Software Question

Were you able to re-rate the question as well to avoid the negative rating from counting for me?

Ask Your Own Software Question
Customer reply replied 29 days ago
I rated 5 starts. If I need to contact support to fix the first one, please let me know

Will do. Thank you. have a great day!

Ask Your Own Software Question
Ask Specialist Sean S. Your Own Question
Specialist Sean S.
Specialist Sean S.
Specialist Sean S., Computer Support Specialist
Category: Software
Satisfied Customers: 1,127
1,127 Satisfied Customers
Experience: 5+ years IT experience. A+, Net+, Security+ certified

Specialist Sean S. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

668 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

502 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Jins M. N.

Computer Hardware Engineer

463 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

454 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

162 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I am trying to get into Google Chrome to one of my
I am trying to get into Google Chrome to one of my favorites. The user name and password ***** correct. I get the following message and it won't open. "Kaspersky secure keyboard input is enabled." Hop… read more
Kamil Anwar
Kamil Anwar
Software Specialist
Bachelor's Degree
454 satisfied customers
Cannot sign on to face book always says connection not
cannot sign on to face book always says connection not secure or privacy concerns what is happening ? tried chrome and edge win 10 desktop… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,112 satisfied customers
Having a problem with Photoshop Lightroom Classic. After
Having a problem with Photoshop Lightroom Classic. After processing in Develope Mode Including Noise Removal.... when moving back to Library of Slide Show all noise and pixellation returns. … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,112 satisfied customers
I want to make my own account to buy extras for games eg
I want to make my own account to buy extras for games eg panda pop. It seems to be using my daughters account … read more
Edward Dorsey
Edward Dorsey
Technician
Associate Degree
16 satisfied customers
I have been knocked off facebook 5 times requesting a
I have been knocked off facebook 5 times requesting a picture be sent. This gas happened within the last four months. Why am I constantly having to verify my account … read more
Mike Taylor
Mike Taylor
40 satisfied customers
Amazon Ritchie ejects my. Amazon rejects my password. For
amazon Ritchie ejects my JA: What's the brand and model of your computer? And the Operating System (OS)? Customer: Amazon rejects my password JA: How long has this been going on with your computer? Wh… read more
Jason Jones
Jason Jones
AAS Information Technology
6,318 satisfied customers
In regards to garageband. i've recorded 8 tracks with no
hi in regards ***** ***** . i've recorded 8 tracks with no glitch. However on playing back the song using the 8 recorded tracks , in different parts at different locations the whole 8 tracks slow down… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,112 satisfied customers
Computer failed when trying to update. Suggested that I
Computer failed when trying to update. Suggested that I reload. I have just renewed my 2 year subscription in October. Reloaded Windows ten. Have now tried tree times to download program but each time… read more
arsufi2002
arsufi2002
Bachelor's Degree
322 satisfied customers
I have been unable to activate my Dreamweaver CS3. I have
I have been unable to activate my Dreamweaver CS3 . I have the serial number. But each time I tried to activate I couldn't connect. … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,112 satisfied customers
My phone is locked that iTunes got it locked out, Georgia,
my phone is locked that iTunes got it locked out JA: What state are you in? It matters because laws vary by location. Customer: Georgia JA: Has anything been filed or reported? Customer: no I can use … read more
Karthik
Karthik
Senior Engineer
Bachelor of Engineering
46 satisfied customers
I need to do inline editing in datatables. I need a FREE
I need to do inline editing in datatables. I need a FREE solution. Please give me links to free code that does this. see https://editor.datatables.net/examples/inline-editing/index.htmlAlso, if there … read more
caraleneK
caraleneK
Service Manager
1,676 satisfied customers
Going in circles. published my ebook with kindle create but
going in circles. published my ebook with kindle create but can't find it or price it or anything. Frustrating … read more
Kris R
Kris R
IT Manager
Computing
2,422 satisfied customers
Want to update Photoshop CC 2017.1 to latest version. Cannot
Want to update Photoshop CC 2017.1 to latest version. Cannot find a way to do this. Do NOT want to have my photographs on the Cloud. Duncan Hartley.***@******.***. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,318 satisfied customers
I have a promo on itune for some 4 years and I never get no
I have a promo on itune for some 4 years and I never get no response as to rather the album sell or not it is Julie marshall gospel inspiration maybe my website is set up wrong I see there are subscri… read more
Josh
Josh
It Support Specialist
Associate Degree
5,134 satisfied customers
At one of my offsite older Dell computer locations, I have a
At one of my offsite older Dell computer locations, I have a dual monitor video card (Radeon). About 30 days ago, and about the time of the Win 10 1709 upgrade, the dual monitors became just two copie… read more
Jason Jones
Jason Jones
AAS Information Technology
6,318 satisfied customers
I am trying to post an article on my steemit account. I have
I am trying to post an article on my steemit account. I have the article in the post area, but I can't send it to my blog. … read more
caraleneK
caraleneK
Service Manager
1,676 satisfied customers
I reset password two weeks ago. I can get emails from Iphone
I reset password ***** weeks ago . I can get emails from Iphone but not computer. what can I do? … read more
Karthik
Karthik
Senior Engineer
Bachelor of Engineering
46 satisfied customers
Does Dragon NaturallySpeaking software work on a mac book? I
does Dragon NaturallySpeaking software work on a mac book? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,251 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x