• 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.

This question generated 34 answers. To proceed to the answers, click here.

This thread is current as of November 13, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel

privacy policy