microsoft excel

I am trying to summarise data wherein alot there are alot of blanks. The only way to list this data properly therefore is by using a pivot table, selecting the parts i want and then filtering them by a seperate coulumn, in this case 'reinsurer'. How do i do the same thing, but outside of a...

I have data of different companies like names, addresses, phone numbers and emails in one column of an Excel workbook. How do I separate these columns using Excel formulas? Here is the sample data: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco...

2014 ModelOff New York Live Finals (FREE) If you’re in New York City this Sunday, join leaders from the Finance and Excel communities to witness the crowning of a new Financial Modeling World Champion. Who will follow in the footsteps of Alex Gordon and Hilary Smart and claim the $30,000USD...

I'm having problem with the formula I'm using in Excel. Here's the link to the sheet, where Sheet 1 is the source data: https://www.dropbox.com/s/ispzi99u884ic9i/New%20Microsoft%20Excel%20Worksheet%20%282%29%20-%20Copy.xlsx?dl=0 I'm using this formula...

Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...

I'm working on a spreadsheet that two conditions have to true in order to be counted. If the month is January, and the number next to it is less than or equal to 30, then it's counted. Same rule applies for all the other months. Thus far, I have...

Hello Admin & Team, First Thread! I am exited to be a part of this this Forum. Need help team, i know this is stupid question which i am asking but i need you help on this. 1) I have created small dashboard which has almost 12 sheets and each has there own monthly data. 2) Now i have created...

Hi, I have 2 excel sheets. (Say "Data" & ""Payment Reminder Letter") Data excel sheet contains sheet 1, sheet 2, sheet 3.... I want copy and paste particular data from data excel sheet to payment reminder letter for each client. Please help me. Thanks, Sam.

Dear Group Members, I have recently joined this group since I have started a University course which requires VBA/SQL programming. Since I have not prior experience in programming, but have some IT knowledge, I would like to ask for your help.:) For my project, I have to come up with a...

Hi I'm new to this group, a friend recommended me to come here. I've uploaded an excel document, which i've linked to below. http://snk.to/f-chk9akpz (Password: MrExcel) I'm trying to pull data from one sheet (project planner) that is displayed in another sheet (summary). But cant seem to...

All, I have the following code which worked in 2010 and I believe was prior to me upgrading my MS Office suite from 2007 to 2010. Might this be an issue between the application versions? When running the program, I get "Bad File Name or Number" run-time error which occurs on the second iteration...

Gents Could you please assist me in the below case: 1- I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with...