| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF not counting
If I am using COUNTIF to compare 2 sets of data (e.g. 2 lists of names) that
I have copied from 2 different websites, COUNTIF does not recognize some names that match. I use TRIM and match the formats and of the 2 data sets, still does not work 100%. Of Course, when I copy the cell from one set (e.g. John Doe) and paste it over the the "John Doe" in the other set, it works. Is there anything else I can do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif counting properties | Excel Discussion (Misc queries) | |||
| Countif and Text - not counting | Excel Discussion (Misc queries) | |||
| Countif - Counting time in a Column | Excel Discussion (Misc queries) | |||
| Using COUNTIF for Counting Words? | Excel Worksheet Functions | |||
| counting values within given interval - countif? | Excel Discussion (Misc queries) | |||
Threaded Mode
