Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in excel
I need to create a spreadsheet that compares two different data base reports
from our software program. One is an open PO report, the other is an open order report. Then end result is to be a report that shows the project number that is open, quantity on PO, and then breaks out how much each distributor has on order, how many royalty (free) items we are sending out, and what the balance is for all other orders. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in excel
Miss Ellie,
A pivot table should be able to do what you describe - there are a lot of pages that will help you get started. If you need specific help, post a very small sample of your data.... HTH, Bernie MS Excel MVP "Miss Ellie" <Miss wrote in message ... I need to create a spreadsheet that compares two different data base reports from our software program. One is an open PO report, the other is an open order report. Then end result is to be a report that shows the project number that is open, quantity on PO, and then breaks out how much each distributor has on order, how many royalty (free) items we are sending out, and what the balance is for all other orders. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formulas | Excel Worksheet Functions | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |