Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Each day I recieve a report that looks as follows:
JSE Trustee -1033652.19 plus Equity purchases 0 plus Equity sales 2671695.15 plus Option purchases 0 plus Option sales 0 plus Bond purchases 0 plus Bond sales 0 plus Dividends accrued 73539.65 plus CFD payments 0 plus SAFEX payments 0 plus Interest Accrued 0 plus Scrip Lending Fees Accrued -10033.9 plus Scrip Lending Interest Accrued 20183.47 plus SettlementFees Accrued 0 plus Currency Forward Settlements Accrued 0 plus Other accruals 0 Every day the report can look different depending on the equity sales or purchases, bond sales and purchases, interest accrued ect. For my daily reporting I need to only extract the items that reflect a change in value. I can ignore the row items containing 0 values. What formula can I use to select the rows that contain values and ignore the rows that contain 0 to import these into my report? Thanks -- H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting rows from a spreadsheet using values from another shee | Excel Discussion (Misc queries) | |||
Extracting values from a table | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Extracting numeric values from string | Excel Worksheet Functions |