How to pick first entry on vlookup and the last entry in diffrent columns

[mercmannick]

Hi

i have Data imported in from SQL DB and it has multiple entries of a product No.

What i need to do on a seperate excel sheet is in Column I have the first entry on the Row
in Column J have the last entry from a vlookup is this possible

enclosed is a sample of what i am trying to do.

Thanks

[code
riref sched_machine sched_start sched_stop
100342 MOLLART 29/03/2011 08:00 29/03/2011 11:00
100342 MOLLART 29/03/2011 12:00 29/03/2011 14:00
100342 MOLLART 29/03/2011 15:00 29/03/2011 16:00
100342 MOLLART 29/03/2011 17:00 29/03/2011 18:00
103986 MOLLART 29/03/2011 19:00 30/03/2011 05:00
code]

 

[mercmannick]

Hi aladin

post 15 has the end results required

post 16 has the sample data

is this what you require

Thanks Nick

 

[Aladin Akyurek]

Hi aladin

post 15 has the end results required

post 16 has the sample data

is this what you require

Thanks Nick

How are post 15 and post 16 related?

 

[Peter_SSs]

Can you post a slightly larger sample of SCHEDULER sheet ...

You posted another sample from SCHEDULER sheet that was exactly the same size as the previous one, and it still does not appear to contain the data that would produce the expected results you provided in post #15.

.. and explanation of why those are the expected results.

Did I miss that? You did make some mention of "machines" and "operations" which no doubt are obvious to you but they mean nothing to me.

Perhaps CR8 on one sheet is equivalent to CRAVEN8 on the other sheet but there is no explanation of that or how we would 'match' other such approximations.

There just doesn't seem like enough detail/explanation to even determine if this is reasonably possible with formulas or vba.

 

[mercmannick]

Post 15 is showing what results i am getting and the results i need

Post 16 is sample data showing how there is multiple operations per roll so it has op start time and end time for both ops

i need to get the start time of the roll and the end time of the roll in the current machine

below is a sample of how 1 roll has multiple operations per machine and multiple machines to go through to complete

Excel Workbook
	B	C	D	E
28	98015	RG02	11/04/2011 03:00	11/04/2011 05:00
29	98015	RG02	11/04/2011 05:00	11/04/2011 07:00
30	98015	CENTRERIG	11/04/2011 07:00	11/04/2011 08:00
31	98015	HERK 1	11/04/2011 23:00	12/04/2011 01:00
32	98015	HERK 1	12/04/2011 01:00	12/04/2011 03:00
33	98015	HERK 1	12/04/2011 03:00	12/04/2011 13:00
34	98015	SAFOP2	13/04/2011 05:00	14/04/2011 03:00
SCHEDULER

there is an example of 1 roll going through multiple machines with multiple ops per machine

what i am trying to get is use HERK 1 as an example

Start time is for roll No 98015 11/04/2011 07:00

end time for Herk 1 is 12/04/2011 13:00

my current sheet i am getting start time of 11/04/2011 03:00 and end of 14/04/2011 03:00

hope this helps

Nick

 

[Peter_SSs]

what i am trying to get is use HERK 1 as an example

Start time is for roll No 98015 11/04/2011 07:00

Hopefully that is a mistake since that start time doesn't seem to me to relate to HERK 1.

Try something like this. These are array formulas so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}.

Excel Workbook
	A	B	C	D
1			Start	Stop
2	HERK 1	98015	11/04/2011 23:00	12/04/2011 13:00
Results

 

[mercmannick]

Brilliant thanks Peter & Aladin

Nick