Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() Hi all, I have an attachment that's apart of this message & within it I have 3 tabs 1) Revenue 2) Expenses & 3) Net Position. I would like to do some Analysis on the above three thou a way where I can manipulate the Data. How would I go about doing this? I've tried a Pivot Table thou it didn’t work out in the sense that it was messy & just failed in calculating stuff, not sure if I did it right thou.. Would really appreciate all the help as I actually have about 20 of these sheets which from that fall into 4 groups being 5 sheets per group. I hope this all makes sense, would appreciate all the help. Cheers Will +-------------------------------------------------------------------+ |Filename: Book44.zip | |Download: http://www.excelforum.com/attachment.php?postid=4750 | +-------------------------------------------------------------------+ -- william4444 ------------------------------------------------------------------------ william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991 View this thread: http://www.excelforum.com/showthread...hreadid=541554 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data analysis option not visible | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
statistics - data analysis tool | Excel Worksheet Functions | |||
Help with data not getting plotted | Charts and Charting in Excel |