Time greater than

[hajiali]

Im trying to writer a code to pull all names that have a start time of 11 or greater cell B2 has the following code

=IFERROR(INDEX('Bid Results'!$X$6:$X$253,SMALL([B]IF('Bid Results'!$Z$6:$Z$253=>TIME(11,0,0)[/B],ROW('Bid Results'!$Z$6:$Z$253)-ROW('Bid Results'!$Z$6)+1),ROWS('Bid Results'!$Z$6:'Bid Results'!$Z6))),"")

What im notice the code is doing is that is recognizing all the "OFF" times as Greater than or equal too 11 Im needing it to Ignore all cells that have "OFF"

 

[jasonb75]

Time is numeric and any text is greater than any number, for this to work correctly you need to eliminate any non-numeric values from the array first.
This formula should do it, array confirmation is not needed.

=IFERROR(INDEX('Bid Results'!$X:$X,AGGREGATE(15,6,ROW('Bid Results'!$Z$6:$Z$253)/(VALUE('Bid Results'!$Z$6:$Z$253)>=TIME(11,0,0)),ROWS(Z$6:Z6))),"")

 

[Drrellik]

So, on your sheet Bid Results in column Z some of the rows have OFF rather than a time and your array formula is evaluating those cells as greater than 11 and returning the rows as a result.

did I understand you correctly?

and your example did not show as an array but you are using Ctrl+Shift+Enter correct?

 

[hajiali]

Thank you SO much Jasonb75 that worked.