Previous Topic Next Topic

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!

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.
0

Similar discussions

VBA find column by name and sort
SidK -
bOFILL -

4 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
How to copy the Column value into Rows
Raj_1562 -
TrowaD -

9 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses