Search : in
By :

Look in a row for a word

Last answer on Sep 28, 2009 2:11:46 pm BST Murph, on Sep 24, 2009 12:49:47 pm BST 
 Report this message to moderators

Hello,

I am looking for a formula that will look in a row G8:IR8 for the any cell that contains "Wrong Stream" (which is there because of an if statement - if(G5<>G10, "Wrong Stream", "") etc for each column).

I need it to look in this row for "Wrong Stream" and if there is a "Wrong Stream" I need it to say "Wrong Stream" in cell F10 and if there are no occurrences of "Wrong Stream" then it is to return nothing.

I have tried using an if statement: =IF(G8:IR8="Wrong Stream", "Wrong Stream", "") but it doesn't work.

I am trying to stay away from macros to make it more user friendly.

Also, if you know of a formula that will make the =MAX() formula keep the formatt of the cell that it picks, that would be greatly appreciated as well.

Thank you in advance for your time and help.

Murph

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Look in a row for a word » in :
Download a free version of Microsoft Word ShowDownload a free version of Microsoft Word Alternatives to Microsoft Word Ability Write Abiword KWord Jarte Word Processor Download a free version of Microsoft Word Microsoft Office Word is a word processing software licensed by...
Background image/ Printed Watermark with Microsoft Word ShowBackground image/ Printed Watermark with Microsoft Word Insert a background image: Insert a Printed Watermark background: You might want to customize the blank background of your Word document either to advertise your business or...
Microsoft word document recovery ShowMICROSOFT WORD DOCUMENT RECOVERY Sometimes large documents containing images files and screenshots, sometimes tends to illogically block Microsoft *Word when you try to modify or edit them. In this case try to proceed as explain below:...
Download Quick Word to PDF ShowTo transfer your documents most in possible security, there is not better than format PDF. Then, to convert your documents Word into PDF, adopt the quick program Word to PDF. Quick Word to PDF is a tool which integrates with the interface of...
Download Word Viewer Show
Download Free PDF to Word Converter ShowDocuments PDF are certainly most on and the most stable for transfers, since they cannot be changed. However, sometimes they need data contained in a document PDF which they would like to edit or to change. Free PDF to Word Converter is as name...
Ask your question Reply

1

 Trowa, on Sep 28, 2009 2:11:46 pm BST

I'm using a dutch version of excel and don't know the exact translation of the functions name.

With the function Compare (?) you can determine the columnnumber of the word you are searching for. If the word is not found you get an error message. Use this function in conjunction with the IF function and you should be able to create a function doing exactly what you want.

If you need more help let me know.

Best regards,
Trowa

   
Reply to Trowa
Ask your question Reply
They need your help