Array

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

I have the function:-

=SMALL(IF(OFFSET(NOV!$A$5:NOV!$A$200,0,MATCH(DAY($B$1),NOV!$A$4:NOV!$X$4,0)-1)="H",ROW(NOV!$A$5:NOV!$A$200),2000),ROW())

I want it to look for H or F

how do I do this
 
Hi
try
=SMALL(IF(OR(OFFSET(NOV!$A$5:NOV!$A$200,0,MATCH(DAY($B$1),NOV!$A$4:NOV!
$X$4,0)-1)="H",OFFSET(NOV!$A$5:NOV!$A$200,0,MATCH(DAY($B$1),NOV!$A$4:NO
V!$X$4,0)-1)="F"),ROW(NOV!$A$5:NOV!$A$200),2000),ROW())
 
Back
Top