| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display cells(text) in one column based on cells which are present inother column
hi all
i have a requirement that in my excel i have 2 columns A and B. column A has some 5 values say they are some names of people. column B has some 2 values . Now i want find out the list of column A names which are also present in column B in a seperate column any help regarding this would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display cells(text) in one column based on cells which arepresent in other column
Something like this?:
=IF(ISNA(MATCH(A1:B:B,0)),"No","Yes") Copy this down as required - this will identify (by means of Yes) if the name in column A can be found anywhere in column B. Hope this helps. Pete On May 12, 11:58*am, wrote: hi all *i have a requirement that in my excel i have 2 columns A and B. column A has some 5 values say they are some names of people. column B has some 2 values . Now i want find out the list of column A names which are also present in column B in a seperate column any help regarding this would be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| adding text to column cell if there's a value present | Excel Discussion (Misc queries) | |||
| Need to parse column data only when text is present | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Linear Mode
