Maybe applying data|filter|autofilter would be a way to show/hide the data you
need.

Or maybe doing data|subtotals would be ok???

ledzepe wrote:

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

--

Dave Peterson