The data is like below:

Acct, Qty, Desc, Wt., Rate, Cost
R123, 2, skids, 40, 11%, 10.00
R123, 0, FCS, 0, 15%, 3.00
R321, 1, skid, 100, 11.2%, 21.00
R321, 2, rolls, 100, 11.2%, 21.00
R321, 0, FCS, 0, 15%, 5.00
R654, and so on...

My recurring data is the first column, "R321" and then I want to
extract the Cost of each line that has R321. There is probably two
thousand lines and 500 accounts in each spreadsheet. My boss wants a
report that would get the cost of any given set of accounts that he
specify.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=513736