Countif formula
 

Hi
I have a worksheet that contains a list of Faults the time the fault
occurred/ ended and the day it occurred on
What i want to do is
count the list the faults that occurr on a certain day
i have set up an index based on the days using
Column AS1 =IF(COUNTIF(N
$1:$N1,N1)1,"",ROW())

i then get the days using
Column AT1
=IF(ISERROR(SMALL(AS:AS,ROWS($N
$1:N2))),"",INDEX(N:N,MATCH(SMALL(AS:AS,ROWS($N$1: N2)),AS:AS,0)))

what i need now is to look at the day and reyrn the faults that occur
for each day

Aand place the reusult in column AT


Any ideas

Thanks


Kevin

Countif formula
 

Kevin,

I am finding it difficult to visualise your spreadsheet, would you care to
restate your question giving a bit more detail.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"kevcar40" wrote in message
...
Hi
I have a worksheet that contains a list of Faults the time the fault
occurred/ ended and the day it occurred on
What i want to do is
count the list the faults that occurr on a certain day
i have set up an index based on the days using
Column AS1 =IF(COUNTIF(N
$1:$N1,N1)1,"",ROW())

i then get the days using
Column AT1
=IF(ISERROR(SMALL(AS:AS,ROWS($N
$1:N2))),"",INDEX(N:N,MATCH(SMALL(AS:AS,ROWS($N$1: N2)),AS:AS,0)))

what i need now is to look at the day and reyrn the faults that occur
for each day

Aand place the reusult in column AT


Any ideas

Thanks


Kevin