excel 2007

  1. L

    Solved SUMIFS help

    I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2)...
  2. S

    Solved Excel 2007 - auto expand cells to fit text

    I have a form for my colleagues to complete and while the majority of the form are drop down boxes I have one free form cell for them to input text. I have set the cell to wrap text but I want the cell to grow automatically to fit the text inputted if it exceeds the space on the form. This will...
  3. V

    compile error in hidden module in excel 2007

    I am doing an income tax (India) return. this is excel utility with a macro. there is one link "generate xml". when I click that I get an error message "compile error in hidden mdoule". what is the solution,. I saw earlier message in the forum...
  4. P

    Excel - Won't roundup entire cell

    =roundup(D55,0)*(1+G54) This won't roundup the sum of the formulas. Ideas?
  5. C

    excel dates

    Filename: SysInfo.exe Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe ____________________________ ____________________________ Developers Not Available Version Identified 6/27/2016 at 5:17:31 PM Last Used Not Available Startup Item...
  6. K

    Solved split numbers & text in a single cell into 2 cells, xl2007

    Hi I have a column of data which contains a reference followed by the customer name. examples:- Cell B1: 0111213729 rivett luke Cell B2: 0122022157 fernandes de souza henrique Cell B3: 0803141945 lopez fernandez eduardo I am using excel 2007 and want to find the code to separate the number...