| Post ID |
Timestamp |
Content |
User |
| 1284097 |
2012-06-27 00:35:00 |
I have created a list of unique names derived from two worksheets using the formula =IF(ISERROR(MATCH('2006'!$A3,'2007'!A:A,0)),'2006' !$A3,""). Now I want to count the number of names in my new list but I can't find a way as cells containing the formula are not considered to be empty. I have tried Countif(a1:a300,"*") but this counts blank cells which contain the formula. Anyone help? I am using Excel 2003. |
bpt2 (6653) |
| 1284098 |
2012-06-27 01:00:00 |
deleted, thats wont work..... |
SolMiester (139) |
| 1284099 |
2012-06-27 02:05:00 |
I have found a solution by changing the formula to =IF(ISERROR(MATCH('2006'!$A3,'2007'!A:A,0)),'2006' !$A3," ") and then using Countif(a1:a300,"*")-Countif(a1:a300," "). I just need to add one additional feature which is to make the count dependent on a number in an adjacent column. Any suggestions? |
bpt2 (6653) |
| 1284100 |
2012-06-27 03:32:00 |
Last question resolved with the formula: =COUNTIF(A$22:A$404,A3)-SUMPRODUCT((A$22:A$404=A3)*(B$22:B$404=" ")) where the adjacent number is in Column A22:A404 and the criteria is in A3. |
bpt2 (6653) |
| 1284101 |
2012-06-27 03:53:00 |
Ok, a self fixed problem:) |
stratex5 (16685) |
| 1 |
|