How do I seperate Negatives from Positives

I'd really welcome some advice.
I'm trying to do some accounts and my bank is not allowing me to download seperate types of transactions.
What I'm wanting is the following:
To seperate crdeits from the debits.
To do so alphabetically, as it makes it easier to put groups of figs. together in the same column - ie pet insurance.
The attachment gives a better understanding.

Many thanks

Book2.xlsxBook2.xlsx

Perhaps, use two extra columns to show.

G6
=IF($F6<0,$F6,"")

H6
=IF($F6>=0,$F6,"")

Both copied down.

Thanks Trevor

It's Excel 2016.

Originally Posted by windknife

Perhaps, use two extra columns to show.

G6
=IF($F6<0,$F6,"")

H6
=IF($F6>=0,$F6,"")

Both copied down.

Many thanks windknife !

Originally Posted by alansidman

@Kuler
Please change your profile to reflect that you are now using XL2016 and not XL2007. Helpers tailor their responses based upon the version of excel you are using.

Thanks, will do.

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.