sorting paypal transactions

[networkmom]

I need to sort all my pay pal transactions I need all my debits in one row and credit in another. I do not know how to use excel very good at all, so if anyone can help me I would appreciate it.

[oldchippy]

Hi,

May be this previous similar question/answer may help?

http://www.excelforum.com/showthread...ghlight=cheque

[networkmom]

Thanks, but that does not help me much.

[networkmom]

Can anyone help with this? If anyone is familiar with the way your pay pal transaction are listed they are all just in there by date with debits and credits all mixed in together, I need to get these seperated so I know the total for debits and the total for credits.

Thanks
Denise

[robert111]

Are you able to electronically copy your paypal statement and paste it into excel. If so, do so, zip the file, attach it to the post and explain in detail what you want to do.

[oldchippy]

Are you able to electronically copy your paypal statement and paste it into excel. If so, do so, zip the file, attach it to the post and explain in detail what you want to do.

Don't forget to remove any personnel account numbers etc. we only need the format on how the data is set up.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.

[networkmom]

Here is just an example, I need to have debits and credits seperated, pretty simple but just do not know how to do it.example.zip

[oldchippy]

Hi,

Try this for Credits in E2 copy down

=IF(B2>0,B2,"")

and this for Debits in F2 copied down

=IF(B2<0,B2,IF(C2<0,C2,""))

[networkmom]

Where do I insert this info? on the top bar?

[oldchippy]

Hi,

The first formula is in cell E2 then drag the formula down the column to E34 with the fill handle.

Put the second formula in F2 and again drag down the column to F34

See this link on how the Autofill (fill handle works)

http://support.microsoft.com/kb/291359

[networkmom]

How do I put the formula in there when there is information in the cell already?

[oldchippy]

networkmom,

The example you posted didn't have anything in columns E or F ????

[robert111]

go to any cell in your column E and insert column, and repeat, you now have E2 and F2 ready to accept formulas

[networkmom]

I think it is not working becase the actual columns I need are different from what I sent you I need row D and E calculated. boy this is confusing to me

Thank you
Denise

[oldchippy]

Hi,

Don't panick, the formulas I gave looks at rows B and C, if your columns are D and E, just edit the formulas to look D and E

=IF(D2>0,D2,"")


=IF(D2<0,D2,IF(E2<0,E2,""))

[networkmom]

Thank you very much. Now if I want to go through all my transaction and say delete certain rows? ex. If I want to delete all my debits from purchases I made that are not business related, like Giant eagle or any store I shopped at. Is there a way to do this?

[oldchippy]

Hi,

Take a look at this link on basic sorting

http://www.contextures.com/xlSort01.html

[robert111]

You could add an extra column to your data and type the word IGNORE against any domestic purchases.

Then you could total all your debits and credits EXCEPT those marked IGNORE

Many ways to do this, but the easiest for you to understand might be in another column next to the IGNORE column (let us say column Z), insert the formula

=if(Y1="IGNORE","",D1) (assumes credits in col D)

and in column AA

=if(Y1="IGNORE","",E1) (assumes debits in col E)

you can then total both those columns, and indeed do a running total.

[networkmom]

So in the quotation I need to tell it what to ignore? Anyone??