Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ideas needed, pls help..
Suppose I have a spreadsheet with the following data
Column A B C D Country Company Profit No. of Employees Hong Kong ABC 1000 10 Hong Kong XYZ 2000 20 UK XXX 1100 14 UK YYY 2500 15 Singapore AAA 3000 30 Australia CCC 1000 20 The data will be collected and updated on a quarterly basis My task is to design a user-friendly spreadsheet, establish a clear set of rules/procedures for on-going updates purpose in order to track our portfolio size Therefore, some of the data will be changed, and some won't . I have now done a summary table with formulas as follows Profit No. of employees Hong Kong UK Singapore Australia Do you have any ideas how I can improve my spreadsheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anyone else have any ideas?? | Excel Discussion (Misc queries) | |||
any ideas appreciated | Excel Worksheet Functions | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Any Ideas? | Excel Worksheet Functions | |||
Any Ideas | Excel Discussion (Misc queries) |