software

I have columns of mfg line, customer, month, weight, and forecast. The same
customer may have forecasts for multiple weights. I would like to be able to
setup a formula to return customer, weight, and forecast if it meets a
specified mfg line and month. My spreadsheet is 7000 rows long and I want to
compare data on a seperate sheet in the workbook.

For example:
Line Customer Weight Month Forecast
A Alpha 10 Mar 300
B Alpha 11 Jan 100
A Alpha 12 Mar 750
A Beta 10 Mar 200

The result for Mar and mfg line A would be:
Alpha 10 300
Beta 10 200
Alpha 12 750

Hi Bob,

just a simple way to do this without a complicated formula (assuming your
list has no empty rows):

1) Click on any cell in your list and select quot;Dataquot; - quot;Filterquot; - quot;Autofilterquot;.
2) Select from the dropdown besides quot;Linequot; the quot;Aquot;.
3) Select from the dropdown besides quot;Monthquot; the quot;Marquot;.
4) Finally select from the dropdown besides quot;Weightquot; the quot;sort ascendingquot;
(not sure if this entry is called like this in english).

Done. Now you should have your correct list.
FYI:
To disable quot;Autofilterquot; simply select quot;Dataquot; - quot;Filterquot; - quot;Autofilterquot; again.

Did this idea solve your question?

Best wishes from Germany,
Eric

quot;Bob Bquot; wrote:

gt; I have columns of mfg line, customer, month, weight, and forecast. The same
gt; customer may have forecasts for multiple weights. I would like to be able to
gt; setup a formula to return customer, weight, and forecast if it meets a
gt; specified mfg line and month. My spreadsheet is 7000 rows long and I want to
gt; compare data on a seperate sheet in the workbook.
gt;
gt; For example:
gt; Line Customer Weight Month Forecast
gt; A Alpha 10 Mar 300
gt; B Alpha 11 Jan 100
gt; A Alpha 12 Mar 750
gt; A Beta 10 Mar 200
gt;
gt; The result for Mar and mfg line A would be:
gt; Alpha 10 300
gt; Beta 10 200
gt; Alpha 12 750

Eric,
Thanks for the help. I was trying to over-complicate what I needed. Using
your idea, I then added subtotals for the lines I wanted to review and I
think it will work. Doing it this way requires me to use some basic
calculations where I would have automated them in the seperate sheet, but it
will work fine.

Bob

quot;Eric_MUCquot; wrote:

gt; Hi Bob,
gt;
gt; just a simple way to do this without a complicated formula (assuming your
gt; list has no empty rows):
gt;
gt; 1) Click on any cell in your list and select quot;Dataquot; - quot;Filterquot; - quot;Autofilterquot;.
gt; 2) Select from the dropdown besides quot;Linequot; the quot;Aquot;.
gt; 3) Select from the dropdown besides quot;Monthquot; the quot;Marquot;.
gt; 4) Finally select from the dropdown besides quot;Weightquot; the quot;sort ascendingquot;
gt; (not sure if this entry is called like this in english).
gt;
gt; Done. Now you should have your correct list.
gt; FYI:
gt; To disable quot;Autofilterquot; simply select quot;Dataquot; - quot;Filterquot; - quot;Autofilterquot; again.
gt;
gt; Did this idea solve your question?
gt;
gt; Best wishes from Germany,
gt; Eric
gt;
gt; quot;Bob Bquot; wrote:
gt;
gt; gt; I have columns of mfg line, customer, month, weight, and forecast. The same
gt; gt; customer may have forecasts for multiple weights. I would like to be able to
gt; gt; setup a formula to return customer, weight, and forecast if it meets a
gt; gt; specified mfg line and month. My spreadsheet is 7000 rows long and I want to
gt; gt; compare data on a seperate sheet in the workbook.
gt; gt;
gt; gt; For example:
gt; gt; Line Customer Weight Month Forecast
gt; gt; A Alpha 10 Mar 300
gt; gt; B Alpha 11 Jan 100
gt; gt; A Alpha 12 Mar 750
gt; gt; A Beta 10 Mar 200
gt; gt;
gt; gt; The result for Mar and mfg line A would be:
gt; gt; Alpha 10 300
gt; gt; Beta 10 200
gt; gt; Alpha 12 750