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

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