Column

Closed

Grace - Feb 20, 2009 at 11:59 AM
bachnotes Posts 8 Registration date Sunday August 17, 2008 Status Member Last seen April 1, 2009 - Feb 21, 2009 at 02:51 AM

Hello,

I am trying to compare 2 columns of information. I need to be able to find the contents of one cell to the contents of the entire adjacent column. For example, I need to know if the contents of cell B5 (along with other cells in column B) can be found anywhere in column A. I tried using the formula =If(b5=A$2:A$404,0,1) but it only works if the content of B5 is in A5, but it could in fact be anywere in column A. Please let me know if there is any other way to accomplish this. Thanks!

Column
How to delete column in word - Guide
Tweetdeck remove column - Guide
Excel count occurrences of string in column - Guide
Excel copy column from one sheet to another automatically - Guide
Excel vba find last non empty cell in column - Guide

1 response

Answer 1 / 1

bachnotes Posts 8 Registration date Sunday August 17, 2008 Status Member Last seen April 1, 2009 1
Feb 21, 2009 at 02:51 AM

hi,
try this link to get all the formulas you want:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPP1,M1
hope it helps you.

Similar discussions

Auto generate serial number in excel based on Column

VBA find column by name and sort

Converting rows of data in notepad to columns

How to copy the Column value into Rows

Sum values from one column if another column equals x

Similar discussions

Subscribe To Our Newsletter!