|
|
 |
| found 212 articles for 0.305 sec |
  |
| Also,
If there is likely to be any blanks then you may want to use this
=IF(C1="","",IF(COUNTIF(C$1:C1,C1)>1,"",COUNTIF($C$1:$C$111,C1)))
otherwise you will get a zero next to the blank cells.
HTH
Martin
"MartinW" <htmw@hotmail.invalid> wrote in message
news:e0wfikQCJHA.5656@TK2MSFTNGP04.phx.gbl...
> Hi Ant,
>
> Put this in D1 and drag down,
>
> =IF(COUNTIF(C$1:C1,C1)>1,"",COUNTIF |
|
 |
|
 |
Group: microsoft.public.windowsce.platbuilder · Group Profile · Search for ADance in microsoft.public.windowsce.platbuilder
Author: Luca Calligaris
Date: Sep 19, 2008 02:30
Count the occurrences, but then hide the results if it's more than 1. =IF(COUNTIF($C$1:C1,C1)=1,COUNTIF(C:C,C1),"") and drag down Anto111 wrote: I Have a worksheet which I am adding rows to as i get information in. One of the columns is country, what I want to do is countif so i know the number of times that a country appears. Basically I am using a simple countif formula
|
| Show full article (0.62Kb) · Show article thread |
|
 |
|
1 ·
2 ·
3 ·
4 ·
5 ·
6 ·
7 ·
8 ·
9 ·
next |
|
|