Can't get hlookup to sync with match and index functions

[Tussus]

So I'm somewhat new to using lookup functions in Excel. I have one spread sheet which will have new data added to it daily. It contains a unique number at the top of each column I can use for Hlookup. The problem that I am having is the data can be found in any of several rows, while the remaining rows will be blank. I am using the match function to find the highest value number below 7000, since the only numbers above that will be the dates.

An example of a column might be

unique # 506049
date may-20

data 2000
date may-10
data 0
date 0
data 1200
date may-18

There are two or three sets of data that I need to pull from dozens of zeros, which will not be in the same spot. My current equation that sort of works is:

=INDEX('[Pre-blend data.xlsx]Sheet1'!$B$1:$J$32,MATCH(7000,'[Pre-blend data.xlsx]Sheet1'!$E$7:$E$32,1)+6,HLOOKUP(C4,'[Pre-blend data.xlsx]Sheet1'!$B$1:$J$2,2,FALSE))

This finds the highest value, so 2000 in the above example. I then have another equation in the next row that is the same, except instead of 7000 for the match lookup value I use the previous answer - 1

The down side to this is the look_up array for the match function has to be manually updated depending on the column the Hlookup finds (changing the E's to F's for example). I thought that I could have '[Pre-blend data.xlsx]Sheet1'!$E$7:$E$32 written just below the unique id # so that a hlookup could pull the column data into the match array, but i get an #value! error. I'm sure there is an easier way to do this, but i can't think of one.

Also if i happen to have two data numbers that are the same in a column, this way would only pull one of them.
I also use this equation to pull the corresponding date by adding +1 to the end of the match function.

 

[Tussus]

Also, where the zeros are in the data and date area, these can be left blank if that somehow makes it easier.

 

[ChrisR]

Hi,

If I understand what you mean try this - MUST BE ENTERED USING CTRL + SHIFT + ENTER as it is an array formula and it will not work otherwise . If done correctly you will see { } brackets appear around the formula automatically.

=IF(H12=E1:F1,MAX(IF(E2:F9>0,IF(E2:F9<7000,E2:F9,0),0)),0)

Change H12 for whatever unique reference cell you want to look for
Change E1:F1 for the range of unique numbers
Chage E2:F9 to your range of numbers and dates.

I've just tested this and it works and will return the max below 7000. Don't forget Ctrl + Shift + Enter!

 

[Tussus]

So I tried the equation and all I could get it to return is a 0 unless it was from the first row, then it returned the max. I have a cut down portion of my file here. I need to be able to pull all the data that isn't zero out of a column using the lot # in row 1. the date also needs to stay with the data above it when the data is pulled. It doesn't matter what order the data gets pulled in which is why i was starting at the max number. I havn't used macros or vba since college but i didn't know if that is the way i need to go.

[TABLE="width: 453"]
<TBODY>[TR]
[TD]Lot #</SPAN>
[/TD]
[TD="align: right"]2068143</SPAN>
[/TD]
[TD="align: right"]2068089</SPAN>
[/TD]
[TD="align: right"]2068002</SPAN>
[/TD]
[TD="align: right"]2067863</SPAN>
[/TD]
[TD="align: right"]2067822</SPAN>
[/TD]
[/TR]
[TR]
[TD]80 pk</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]80 pk</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]72 pk</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]1770.00</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]5/16/2013</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]72 pk</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]1076.00</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]16-May</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]15 pk</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]90
[/TD]
[TD="align: right"]1891</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]1004.00</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]460.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]5/16/2013</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]16-May</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]14-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]90
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]1000.00</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]16-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]85
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]85
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]50
[/TD]
[TD="align: right"]3274</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]1715</SPAN>
[/TD]
[TD="align: right"]1832</SPAN>
[/TD]
[TD="align: right"]2078</SPAN>
[/TD]
[/TR]
[TR]
[TD]Date</SPAN>
[/TD]
[TD="align: right"]5/17/2013</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]17-May</SPAN>
[/TD]
[TD="align: right"]17-May</SPAN>
[/TD]
[TD="align: right"]17-May</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[ChrisR]

The data you are posting makes no sense to me.............Try posting so it's in spreadsheet format.........Look in the stickys how to do this, there are many different ways to do this, I personally use ExcelJeanie.

It makes it 1000 times more difficult to interpret data and is just copied and pasted and it means I end up having to provide several answers instead of just one if I could actually see the data to begin with.

Please post this up and then I will try to assist further.

Regards,
Chris

 

[Tussus]

So what i have is incoming material that gets used in different ways, and in different combinations. So there will be a lot of zeros for all the materials that were not used in a blend. For the ones that are used, there is an amount, and a corresponding date. I need to find a way to pull this data (without the zeros) to another sheet, and i need the date to stay with the material amount it is associated with. My orginal formula would look up the max in the column, i coud then adjust that formula to pull the next row down by adding one to the match function. Then I would locate the next highest value, and repeat until it pulled a zero. As I stated before, there are to many problems with how this would work, so I'm looking for an alternative that I dont know about, or have not thought of.

Excel Workbook
	A	B	C	D	E	F
1	Blend Lot #	2068143	2068089	2068002	2067863	2067822
2	80 pk	0	0	0	0	0
3	Date	0	0	0	0	0
4	80 pk	0	0	0	0	0
5	Date	0	0	0	0	0
6	72 pk	0	1770.00	0	0	0
7	Date	0	5/16/2013	0	0	0
8	72 pk	0	0	0	1076.00	0
9	Date	0	0	0	16-May	0
10	50 pk	0	0	0	0	0
11	Date	0	0	0	0	0
12	50 pk	0	0	0	0	0
13	Date	0	0	0	0	0
14	15 pk	0	0	0	0	0
15	Date	0	0	0	0	0
16	15 pk	0	0	0	0	0
17	Date	0	0	0	0	0
18	90 Beef	1891	0	1004.00	0	460.00
19	Date	5/16/2013	0	16-May	0	14-May
20	90 Beef	0	0	0	0	1000.00
21	Date	0	0	0	0	16-May
22	85 Beef	0	0	0	0	0
23	Date	0	0	0	0	0
24	85 Beef	0	0	0	0	0
25	Date	0	0	0	0	0
26	50 Beef	3274	0	1715	1832	2078
27	Date	5/17/2013	0	17-May	17-May	17-May
Sheet

 

[ChrisR]

Right, OK........I understand what you are trying to do now...............

Here is how I have set out the data............

Cell H3 is where you will enter what Blend you want to look at.........

Here are the formulas in I3:K4 . Note they are array formulas so will need to be entered with CTRL + SHIFT + ENTER FOR THEM TO WORK

If you need anymore than the top three then just copy the formula across further and change the last digit (You will see there is a 1, 2 & a 3 in the formulas beklow for the top three)

The formulas in row 3 pull through the figures, the formula in row 4 pull through the corresponding dates.........

Hope this helps.........
Regards,
Chris



[TABLE="width: 85%"]
<TBODY>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<THEAD>[TR="bgcolor: #dae7f5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</THEAD><TBODY>[TR]
[TH="width: 10, bgcolor: #dae7f5"]I3[/TH]
[TD="align: left"]{=LARGE(IF($B$2:$F$27<40000,IF($H$3=$B$1:$F$1,$B$2:$F$27,0)),1)}[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #dae7f5"]J3[/TH]
[TD="align: left"]{=LARGE(IF($B$2:$F$27<40000,IF($H$3=$B$1:$F$1,$B$2:$F$27,0)),2)}[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #dae7f5"]K3[/TH]
[TD="align: left"]{=LARGE(IF($B$2:$F$27<40000,IF($H$3=$B$1:$F$1,$B$2:$F$27,0)),3)}[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #dae7f5"]I4[/TH]
[TD="align: left"]{=IF(I3=0,"",LARGE(IF($B$2:$F$27<40000,IF($H$3=$B$1:$F$1,OFFSET($B$2:$F$27,1,0),0)),1))}[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #dae7f5"]J4[/TH]
[TD="align: left"]{=IF(J3=0,"",LARGE(IF($B$2:$F$27<40000,IF($H$3=$B$1:$F$1,OFFSET($B$2:$F$27,1,0),0)),2))}[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #dae7f5"]K4[/TH]
[TD="align: left"]{=IF(K3=0,"",LARGE(IF($B$2:$F$27<40000,IF($H$3=$B$1:$F$1,OFFSET($B$2:$F$27,1,0),0)),3))}[/TD]
[/TR]
</TBODY>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</TBODY>[/TABLE]



Excel 2010

	A	B	C	D	E	F	G	H	I	J	K

<TBODY>
[TD="align: center"]1
[/TD]
[TD="bgcolor: #ffff00"]Blend Lot #
[/TD]
[TD="bgcolor: #ffff00, align: right"]2068143
[/TD]
[TD="bgcolor: #ffff00, align: right"]2068089
[/TD]
[TD="bgcolor: #ffff00, align: right"]2068002
[/TD]
[TD="bgcolor: #ffff00, align: right"]2067863
[/TD]
[TD="bgcolor: #ffff00, align: right"]2067822
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2
[/TD]
[TD="bgcolor: #ffffff"]80 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #ff0000"]1st Match
[/TD]
[TD="bgcolor: #ff0000"]2nd Match
[/TD]
[TD="bgcolor: #ff0000"]3rd Match
[/TD]

[TD="align: center"]3
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #ffff00, align: right"]2068002
[/TD]
[TD="align: right"]1715
[/TD]
[TD="align: right"]1004
[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4
[/TD]
[TD="bgcolor: #ffffff"]80 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]17/05/2013
[/TD]
[TD="align: right"]16/05/2013
[/TD]

[TD="align: center"]5
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6
[/TD]
[TD="bgcolor: #ffffff"]72 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]1770
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]5/16/2013
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8
[/TD]
[TD="bgcolor: #ffffff"]72 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]1076
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]16-May
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10
[/TD]
[TD="bgcolor: #ffffff"]50 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12
[/TD]
[TD="bgcolor: #ffffff"]50 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14
[/TD]
[TD="bgcolor: #ffffff"]15 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16
[/TD]
[TD="bgcolor: #ffffff"]15 pk
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18
[/TD]
[TD="bgcolor: #ffffff"]90 Beef
[/TD]
[TD="bgcolor: #ffffff, align: right"]1891
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]1004
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]460
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"]5/16/2013
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]16-May
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]14-May
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20
[/TD]
[TD="bgcolor: #ffffff"]90 Beef
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]1000
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]16-May
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22
[/TD]
[TD="bgcolor: #ffffff"]85 Beef
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24
[/TD]
[TD="bgcolor: #ffffff"]85 Beef
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26
[/TD]
[TD="bgcolor: #ffffff"]50 Beef
[/TD]
[TD="bgcolor: #ffffff, align: right"]3274
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]1715
[/TD]
[TD="bgcolor: #ffffff, align: right"]1832
[/TD]
[TD="bgcolor: #ffffff, align: right"]2078
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27
[/TD]
[TD="bgcolor: #ffffff"]Date
[/TD]
[TD="bgcolor: #ffffff, align: right"]5/17/2013
[/TD]
[TD="bgcolor: #ffffff, align: right"][/TD]
[TD="bgcolor: #ffffff, align: right"]17-May
[/TD]
[TD="bgcolor: #ffffff, align: right"]17-May
[/TD]
[TD="bgcolor: #ffffff, align: right"]17-May
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</TBODY>

Sheet4​

 

[Tussus]

This is absolutly perfect. Thank you for taking the time to solve my problem, and for having the patience to teach me a few cool tricks dealing with Excel. I learned a lot from this experience.

 

[ChrisR]

This is absolutly perfect. Thank you for taking the time to solve my problem, and for having the patience to teach me a few cool tricks dealing with Excel. I learned a lot from this experience.

Hi,

No problem, thanks for the feedback and I'm glad this solved your issue!