| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif and concatenate
JP Long wrote...
.... Cell A43 reads: =CONCATENATE('Contact Info'!B2," ",'Contact Info'!A2) resulting in the cell populating with a name (i.e. Shelly Bell) I want to determine how many times that specific name repeats in data found elsewhere in the worksheet. These results will be displayed in C43; the search is occurring C10:C38. I have tried =COUNTIF (C10:C38, "A43") but xl looks for A43 as the text. I have tried =COUNTIF(A43,C10:C38) the other way and the formula box shows "Shelly Bell" as the results of A43; however, the results still come back as zero (0). Have you tried =COUNTIF(C10:C38,A43) ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenation in a CountIf | Excel Worksheet Functions | |||
Threaded Mode
