Solved

Which formula works for this situation?

Posted on 2014-09-15
2
69 Views
Last Modified: 2014-09-15
I have a list of names in Column G, and I need to know if those names also appear in column O, and I would like the results to be displayed in Column H.

Which formula should I use and how do I input that data?
thank you.
0
Comment
Question by:binaryman101
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 40323950
Try using this formula in H2 copied down

=COUNTIF(O:O,G2)>0

You get TRUE or FALSE results

regards, barry
0
 

Author Closing Comment

by:binaryman101
ID: 40324194
perfect thank you!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now