Extracting changing row values
 

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

Extracting changing row values
 

first use Text to Columns to place the data in separate fields. For example:
JSE Trustee in A1
-1033652.19 in B1

then use AutoFilter to hide the rows with zero in column B


--
Gary''s Student
gsnu200711