| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there formula to identify the matching data in Column B?
Hi,
I have Column A that has some matching data in Column B. Is there formula to identify the matching data in Column B? or, maybe create a column C for placing the matching data? -- Thank you, Cpviv |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there formula to identify the matching data in Column B?
one way might be to use COUNTIF function
=COUNTIF(A1:A100,B1) the result would be the count of B1 in A1:A100 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| identify missing data b/t columns and then paste in anthoer column | Excel Discussion (Misc queries) | |||
| How do I identify cells with matching numbers within a column. | Excel Worksheet Functions | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
| Formula to Identify Column Number | Excel Discussion (Misc queries) | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
Linear Mode
