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)...
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...
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...
Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe
6/27/2016 at 5:17:31 PM
I have a column of data which contains a reference followed by the customer name.
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...