Vlookup & Sort Sort Combination

[omer1234]

Hi ,

I could use some help here.

The first worksheet "feb" is raw data"
The second worksheet in tehi sspreadsheet "summary" is where I need help.

I need the data sorted by date "Smallest to Highest" and then the corresponding values, which I though could be done with VLOOKUP but I am unable to sort the dates ( The one tricky part is the empty date in worksheet FEB, I need this to be part of the data even though there is not date assigned to it)

THANKS for the help in advance.


Worksheet Feb

<style type="text/css"><!-- body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small } --> </style>

987654	Leaking Drums	56098345	33			0%		100%	2/5/2016
654321	Bent Drums	87562.00	0	12.4	$-	33%	$-	10%
123456	Dirty Drums	123234	400	18	$7,200	33%	$4,824	100%	2/5/2016
456789	Rusty Drums	349058	70	17.2	$1,204	0%	$1,204	100%	2/26/2016
987654	Leaking Drums	304598	76	40.05	$3,044	33%	$2,039	10%	1/8/2016
654321	Bent Drums	98234	5	16.01	$80	33%	$54	100%	2/5/2016
123456	Dirty Drums	785434	24	12.93	$310	33%	$208	75%	2/5/2016
456789	Rusty Drums	78978	4	17.07	$68	33%	$46	100%	1/29/2016
987654	Leaking Drums	234245	499.00	$4.68	$2,335	0%	$2,335	75%
654321	Bent Drums	67567	499.00	$4.68	$2,335	0%	$2,335	100%
123456	Dirty Drums	67869789	8.5	$298	0%	$298	100%	2/5/2016
456789	Rusty Drums	F9023487	102.00	$4.68	$477	0%	$477	90%
987654	Leaking Drums	J90845	0.00	$4.68	$-	0%	$-	10%
654321	Bent Drums	R908345	142.00	$4.68	$665	0%	$665	100%
123456	Dirty Drums	M983745	23.56	13.20	$311	0%	$311	1%	2/5/2016
456789	Rusty Drums	K938475	1.5	11.59	$17	0%	$17	100%	1/29/2016
987654	Leaking Drums	987345	50	8.3	$415	0%	$415	100%	1/29/2016
654321	Bent Drums	12313	50	8.3	$415	0%	$415	50%	2/26/2016
123456	Dirty Drums	RK9856453	1	15	$15	0%	$15	100%	2/12/2016
	UMARY TAB <style type="text/css"><!-- body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small } --> </style> <colgroup width="65"></colgroup> <colgroup width="129"></colgroup> <colgroup span="3" width="65"></colgroup> <tbody> [TD="colspan: 4"]Feb Summary

<colgroup width="98"></colgroup> <colgroup width="196"></colgroup> <colgroup width="94"></colgroup> <colgroup width="68"></colgroup> <colgroup width="75"></colgroup> <colgroup width="70"></colgroup> <colgroup width="68"></colgroup> <colgroup width="106"></colgroup> <colgroup width="60"></colgroup> <colgroup width="81"></colgroup> <colgroup width="68"></colgroup> <tbody>
[TD="bgcolor: #FFFF00"] Rework Code [/TD]
[TD="bgcolor: #FFFF00"] Rework Description [/TD]
[TD="bgcolor: #FFFF00"] Order # [/TD]
[TD="bgcolor: #FFFF00"] GALS [/TD]
[TD="bgcolor: #FFFF00"] Cost [/TD]
[TD="bgcolor: #FFFF00"] Cost 2 [/TD]
[TD="bgcolor: #FFFF00"] Status 1 [/TD]
[TD="bgcolor: #FFFF00"] Total Cost [/TD]
[TD="bgcolor: #FFFF00"] Status 2 [/TD]
[TD="bgcolor: #FFFF00"] Sched WK [/TD]

[TD="bgcolor: #FFFFFF"] 35 [/TD]

	J	I	C	H
#	Date	Status 2	Order#	Total Cost
1
2
3
4
5
6
7
8
9
10

[TD="bgcolor: #FFFF00"]Smallest to Largest[/TD]

</tbody>

<style type="text/css"><!-- body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small } --> </style>

	Date	Status 2	Order#	Total Cost
1
2
3
4
5
6
7
8
9
10

<colgroup width="65"></colgroup> <colgroup width="129"></colgroup> <colgroup span="4" width="65"></colgroup> <tbody>
[TD="colspan: 4"][/TD]

</tbody>

[/TD]

</tbody>

 

[omer1234]

I can send a spreadsheet if that helps? send me the email address

 

[omer1234]

Anyone?