Splitting Data
Hi, I have an excel spreadsheet with 4000 rows. Sample data from the Amount
column is as follows:
Amount
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
-£8.99
-£44.57
-£30.00
-£9.39
-£20.00
£100.00
Is there a quick way to seperate this data into positve and negative amounts
to give:
Credit Debit
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
-£8.99
-£44.57
-£30.00
-£9.39
-£20.00
£100.00
Many Thanks
|