Countif formula

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

kevcar40

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top