how to cross check data based on time format

**legolas** · 03-08-2012, 05:14 AM

Dear All,

i got a task where i need to find who drove a vehicle on a certain time.
my given data is vehicle make, driver, and time range. so the issue is to compare time range VS fixed time
( attached file with details in H)

is it possible in H to have a formula or UDF so that : if F=B , and G between C&D , then copy A to H.

thanks for any help .

regards

**johnjohns** · 03-08-2012, 05:27 AM

Could not download your file. But this could be the formula for

if F=B , and G between C&D , then copy A to H.

Please Login or Register  to view this content.

**legolas** · 03-08-2012, 05:45 AM

ok I uploaded my file.

**legolas** · 03-08-2012, 03:39 PM

Originally Posted by johnjohns

Could not download your file. But this could be the formula for

Please Login or Register  to view this content.

I think i need an array formula

**legolas** · 03-12-2012, 02:47 AM

is it not possible to compare a fixed time VS a time range

any help on this one please or i can just ignore

thanks again

**bebo021999** · 03-12-2012, 05:44 AM

Try this in H2:

Please Login or Register  to view this content.

Confirmed with Ctrl-Shift-Enter

**estige** · 03-12-2012, 05:47 AM

Maybe something like:
=INDEX($A$2:$A$18,SUMPRODUCT(($B$2:$B$18=F2)*($C$2:$C$18<=G2)*($D$2:$D$18>=G2),ROW($A$2:$A$18))-1,1)

**legolas** · 03-14-2012, 03:49 AM

Dear all

I am still can't get it to work so i uploaded part of my actual file

kindly take a look, thanks a lot

**estige** · 03-14-2012, 05:43 AM

Here is my suggestion.

**legolas** · 03-19-2012, 05:00 AM

@ OnErrorGoto0 & @estige

excatly what i need
thanks a lot

how to cross check data based on time format

LinkBack

Thread Tools

Rate This Thread

Display

how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Re: how to cross check data based on time format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions