• Hot Topics

# Excel Accountant needs Excel help, very difficult formula set up!!!!

Hey! I am a tax accountant trying really hard to impress my manager...long story short one of our big clients give us a very un organized Excel sheet of there trial balance... and I want to find a quick way to organize it...below is an example of what the excel looks like and what I want to look like... (Bold represent columns and rows of an excel and periods are just fillers) A .................B ............C .................D..... 1.Cash......... .............\$1,234 .........\$1,235 2. ......................................................... 3.1000.................................................... 4.Petty Cash.............. \$1,456CR .......1,567CR 5............................................................... 6.1001..................................................... We have over 4,000 accounts ... so we have couple of issues... I need to take the account number "1000" and place it in B next to cash. I also need to take any number in column C or D with a "CR" and turn that number into a negative. So it should look like this.... A...................... B..................... C ......................D 1.Cash.............. 1000.............. \$1,234 .................\$1,235 2. Petty Cash..... 1001............. -\$1,456............... -\$1,567 3............................................................................... 4............................................................................... Make sense? Can you please help!!! Last edited by TDaoud; Nov 13th, 2013 at 02:52 PM.