Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two columns and display value in 3 cloumn
Hi
I have data in Excel Sheet in the following way A B C 123 234 1 2 2 123 The data in Column B have to compare the value in Colmun A and if found the value have to be displayed in Column c Can you please me regarding htis issue. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two columns and display value in 3 cloumn
are you looking for sth like this:
=IF(COUNTIF($A$1:$A$100,B1)0,B1,"") On 12 Gru, 17:19, Raj wrote: Hi I have data in Excel Sheet in the following way A * * * * B * * * *C 123 * *234 * 1 * * * *2 2 * * *123 The data in Column B have to compare the value in Colmun A and if found the value have to be displayed in Column c Can you please me regarding htis issue. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two columns and display value in 3 cloumn
=If(ISNUMBER(MATCH(B1,A1:A3)),A1,"Not found"
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Raj" wrote: Hi I have data in Excel Sheet in the following way A B C 123 234 1 2 2 123 The data in Column B have to compare the value in Colmun A and if found the value have to be displayed in Column c Can you please me regarding htis issue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging rows & Cloumn( Please help me) | New Users to Excel | |||
Compare several columns of data and display unique ones | Excel Discussion (Misc queries) | |||
I am looking for a imple formula for excel i need Cloumn be to be | Excel Discussion (Misc queries) | |||
compare two columns and display a third | Excel Discussion (Misc queries) | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |