excel 2007

Here is what I've tried. MReg_2 is a function where the result (X) will be either 0, 1, 2. c is a cell (offset of field 28), holding a text entry which is numeric or alpha/numeric (e.g. "17" or "127x" but only the numeric value is used. MDate is a date. OS is win 7, Excel is 2007. I'm hoping...

I want to remove values from one duplicate cell to another For example : Column A Column B 1506 1670 Duplicate 1506 1670 Duplicate I want to remove duplicate value from Column B and column A value remain...

I'm trying to match comma separated ID Data to the LOOKUP table and return the NAMEs of the IDs also as comma separated. The last column shows what the required output should look like, and the Current Formula Name Output is the results I have from my formula, which is working correctly. -...

Dear Experts How do I add ROUND,0 to below formula...

In Excel 2007 I Create file and macro (vba), I protected workbook using password and to avoid Security warning when closing file through icon red (X) and reopen file and after save my data and indeed, the problem is solved Steps 1- to avoid Security warning (code problem solved is down )2-...

i want to take the data in the range C12:K20 and extract only the green colored cells into a list under A1. https://www.dropbox.com/s/51phis2d5cb36ko/Screenshot%202018-12-19%2001.56.35.png?dl=0

Hi community. Hope you can help a VBA novice. I've found some VBA code which enables charts in excel to be pasted in to a Word doc. See code below. I want to enhance this further so could you advise on how I do the following: delete the charts in the word doc (40+ each with its own bookmark...

Hi I am still learning Excel and I am very grateful to the good folk on here who generously give their time to answer all of our questions - Thank you. I am writing a simple If formula that looks at cell B1 and if B1 contain the number 1 the formula does one thing but if it contains a different...

Hi all, Searched a number of forums/website but can't find a solution to my issue. I have the following range examples. I have split the string field below to create start and end fields. Match to identify if numbers match and the difference between the two numbers. <colgroup><col><col...

Can the following be done with a excel formula as I am unable to get it right? I am using Excel 2007 on Windows. If cell A1 is formatted as 'General' then return the contents of cell B1 but if A1 is formatted as a 'Date' then return the contents of cell C1. I can find a lot of information...

I have a scoring matrix for a number of services. Each service has its own RAG status. Example below. <tbody> Minutes <30 30-59 60-89 90-119 120-149 150-179 1 2 3 4 5 6 Serv1 3 3 6 9 12 15 18 Serv2 3 3 6 9 12 15 18 Serv3 2 2 4 6 8 10 12 Serv4 1 1 2 3 4 5 6 </tbody> I...

I am monitoring service outages using excel 2007. I have a start and and end time as shown in the example below. Start and end time are in dd/mm/yyyy hh:mm:ss format. <tbody> Start End Days Hours 03/01/2018 18:30:00 04/01/2018 02:42:00 0.342 8.20 </tbody> Days is worked out using the...

Hello All, I am working on a project and needed some help with code. What I am trying to achieve; Step 1 "Sheet 1" - Contains my list of unique values in Column A - Range A2:A50 - there are 3 blank rows before the next new unique value is found, for example: 1st value is in cell A2...

i have a table like this BANKNIFTY BANKNIFTY BANKNIFTY BANKNIFTY BANKNIFTY BANKNIFTY NIFTY NIFTY NIFTY i want to find address of the cell on which a text occurs first time and last time in a column.eg in above address of first row and sixth row in case of banknifty, and 7th row and 9th...

Ok, I have a weekly revenue report that several managers must complete each week. It uses command buttons to guide them through it with userforms. Long story short, 2 managers are using Excel 2007 and it keeps turning on design mode when they save it and exit. Some things I've done: Saved...

There are two problems suddenly I encounter windows 7. Microsoft office 2007 2007. 1. in the excel entries are in yellow color. Is it normal and is it default color 2. I am not able to print excel. It comes out blank. I have designated print area in "page layout". This is a recent problem...

Hi all, I've searched the web for an answer so I'm hoping this can be done. Basically I am creating a BOM (Bill Of Materials). I am ordering cable in pre manufactured lengths. The cables basically has the same part number A0090CEGAC0BUXXXM the XXX represents the cable length. I also have to...

I am using Excel 2007 and asking your help for the best (and the easiest) way to highlight the names of people who have 6-month of consecutive attendance every Sundays. My worksheet's layout are as follow: Column A: Last Name Column B: First Name Row 9: Dates (with "S9" as Jan...

I am using Excel 2007 to make an attendance sheet with cell "S9" starting as January 01, 2017 through "NS9" as December 31, 2017. I am hoping that if the user of the form inputs a date (1/03/2017 as an example) in a specified cell (say B3) then the columns with other dates would "temporarily"...

HI I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine. However, ComboBox2 doesn't seem to display the...