microsoft excel

  1. H

    Excel VBA Will Not Recognise AutoFilter Is Enabled

    Excel vba will not recognise that AutoFilter is enabled. However, it works on the initial sheet which the code is run from. Using code: If ActiveSheet.AutoFilterMode Then Option 1 Else Option 2 End If I have tried to use vba prior to the above code, to remove and re-add the...
  2. S

    Excel table equivalent to tree diagram

    How do I create a 12-month table with several variables in Excel? Say I start with 5 possible X values and have two growth factors, each with 5 proposed values I want to test (Z1-5+Y1-5) through the end of the 12th month and see the product of each combination (125) like a large tree diagram would.
  3. S

    Concurrent Calls in Excel

    I am trying to find a formula to find the number of concurrent calls at one time. My columns contain phone provider, outbound number, inbound number, start date and time (one cell), duration of call, and end date and time (one cell) from A to H in the order they are listed. In this stage of the...
  4. U

    Formula to identify status of requisition when there are multiple possible scenerios

    I am hoping to find assistance with a formula that will help me identify which requisitions have been fully or partially awarded. Each requisition may have multiple lines and none, some, or all of the lines might be awarded. In the example below Requisition 111111 has three line items, but...
  5. B

    Punctuate text in MS-Excel

    Hello, I have a thousands of columns of quotations in MS-Excel. I would like to punctuate them. Is there a formula I can use to do it? For Example: I would like to change: abc to "abc". Thanks in advance.
  6. F

    Access / Power Pivots / Get & Transfer Data

    Hi, Wondering if someone can help with outlining the key benefits, restrictions and differences between Microsoft Access, Power Pivots in Excel and Get and Transfer data function? I have two separate documents of data: one product sales by line by store and one with stock holding by line by...
  7. C

    How to show Data dependent on Dropdown List from different tables

    I am new to Excel formulas. I have 3 list in 3 different columns in Sheet2 as below. <colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody> <tbody> List1 List2 List3 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 6 6 7 7 8...
  8. H

    Automatic update of a cell based on the value of a cell in another worksheet

    Hello, I would like to know if there is a way to automatically update the content of a cell based on the value of a cell in another sheet ? That original cell's value is based on a drop down menu. Could someone exlpain to me how to make it work ? Thank you very much for your help
  9. P

    vba help for 5 minutes data copy, store and auto stop

    Hi there, In my worksheet prices update from trading terminal every minute for 27 stocks. sheet 1 named "bank" has 27 stocks where from F3 to F29 live prices of 27 different stocks are streaming and changing. Now what I need... 1. After 3 minutes of market opening time 9.15 A.M, prices get...
  10. S

    Need help creating a macro

    Hi, Thank you for reading this thread. I need your help creating a macro. I have two excel spreadsheets. .i.e 1) Pivot table 2) Reports. (Report file is shared). The data in the both spreadsheets is as under. Column A) Client names Column B) Outstanding balance. I want to create a macro...
  11. J

    Finding nth Duplicate In A Horizontal List

    Hi there. This seems like it should be really easy, but I've been wracking my brain over it for the last few hours. I have a spreadsheet I'm using that has a number of locations in one row, and I want to retrieve the data from the appropriate column based on the location name. For the most...
  12. D

    Validate two words from cell using two other columns Microsoft Excel

    I've got what's probably a simple question concerning Microsoft Excel 2013 that I just can't figure out the answer to. I have cell A1 that contains a name in the form of two words, such as "Jane Doe". In two separate columns, I have separate lists of first and last names. Here's what it looks...
  13. J

    Excel to Word AutofitContent

    Hello, I have the below code that will copy a table in Excel and then paste it into Word. However I cannot get it to autofitcontents to the page: Sheet2.Range("F6:L" & (46 - Application.WorksheetFunction.CountBlank(Sheet2.Range("F6:F51"))) + 5).Copy...
  14. C

    How do i change date from in a pivot table to normal data

    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...
  15. A

    Separating data in different columns in Microsoft Excel

    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...
  16. M

    Finals in New York this Sunday

    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...
  17. L

    Copying data using VLOOKUP error

    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...
  18. M

    ModelOff 2014 - starts 25th October!

    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...
  19. C

    Two conditions must be true to be counted.

    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...
  20. E

    Multiple Sheets Data in One Sheet

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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top