NOTES AND ORDER OF OPERATIONS
First Setp N/A Delete all "N/A" in this column
Second Step 1011 Copy the CHECK NUMBER to the DESC column as such "Check 1011"
Third Step TYPE Look at value (see formula in cells) If balance less than zero enter CREDIT, if balance greater than zero enter DEBIT.
Fourth Step Value Remove all minus signs from the numbers (note multiplying by -1 will NOT work).
Fifth Step TYPE Sort by this column and make two new spreadshets in this same book. One called DEBIT and another called CREDIT
Copy all CREDIT to the CREDIT tab along with the header of this sheet.
Copy all DEBIT to the DEBIT tab along with the header of this sheet.