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!!!


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