If an Excel row contains particular words, return that row, highlight that row, or give Y/N for that row

Posted by NIranjan on Super User See other posts from Super User or by NIranjan
Published on 2012-08-30T11:28:40Z Indexed on 2012/09/26 9:41 UTC
Read the original article Hit count: 309

Filed under:

microsoft-excel

|

find

|

formula

I have a sheet containing thousands of cells in a column. These cell contains names of different securities.

Some names of these securities contains a particular string such as "C/O".

How can I use a formula that will return the rows that have these characters?

EG.  
S&P 500 C/O 30/03/12 1380  
MICROSOFT C/O 19/05/12 32  
QUICKSILVER C/O 17/03/12 9

There is no consistency (can't use left/right/mid formula).

Requirement : I want the formula which will return "C/O" in the other cell if this particular cell contains it.

© Super User or respective owner

Related posts about microsoft-excel

Connecting to Microsoft Excel using Oracle Data Integrator

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more details on these elements, please refer to the ODI Tutorial… >>> More
Connect Microsoft Excel To SQL Azure Database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
A number of people have found my post about getting started with SQL Azure pretty useful. But, it's all worthless if it doesn't add up to user value. Database are like potential energy in physics-it's a promise that something could be put in motion. Users actually making decisions based on analysis… >>> More
How to code Microsoft Excel "Shift Cells Up" feature in SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column… >>> More
a question on using Microsoft Excel to do data analysis

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone there, Me and my mates have been given an Excel spreasheet,which contains the data of the Census report. The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year. We are up to doing some analysis… >>> More
Working with PivotTables in Excel

as seen on How to geek - Search for 'How to geek'
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them. Note: This article… >>> More

Related posts about find

Microsoft Management Console stops working when I add snap-in to it

as seen on Super User - Search for 'Super User'
I have Windows 7 Ultimate OS. I'm opening mmc.exe as administrator and trying add Certificates or any other snap-in, then while loading that snap-in MMC breaks and displays following message and after that it closes automatically once I click on close button on that message. What could be the problem… >>> More
Visual Studio Find and Replace Regular Expressions ~ find lines with quoted strings, not containing

as seen on Stack Overflow - Search for 'Stack Overflow'
Visual Studio Find and Replace Regular Expressions Find lines with quoted strings, not containing strings include or trace i am tryling to find out all lines in c++ project that contains some text as i have to use visual studio, i have to use its Find and Replace http://www.codinghorror.com/blog/2006/07/the-visual-studio-ide-and-regular-expressions… >>> More
Find, Find Next?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I am trying to make a find, find next function for my program, which I did manage to do with this code: int findPos = 0; private void button1_Click(object sender, EventArgs e) { try { string s = textBox1.Text; richTextBox1.Focus(); … >>> More
In jQuery, using the "find' function, what does this expression mean: $(".divName").find('> div')

as seen on Stack Overflow - Search for 'Stack Overflow'
I understand the "find" function, I'm just not familiar with what ' div' means. Can anyone help? >>> More
Find which config file Apache uses to find virtual host

as seen on Super User - Search for 'Super User'
I have a rather complicated Apache setup: some config files have to be manually written and some have to be automatically generated. So far, I've had no problems. But now, I've just tried to set a site at: newsubdomain.mydomain.com and Apache directs it to the data for: www.someotherdomain.com I've… >>> More