excel 2007

  1. D

    Filter a range where criteria is the result from a function that uses 2-fields in the range

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

    How to remove duplicate values from one cell to another

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

    Transform comma separated ID's into comma separated Names in Excel 2007/10 using lookup table

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

    Rounding an IF statement

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

    VBA Excel 2007 Security warning when closing workbook with Task Manager

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

    Extract multiple data from cells in a range based on cell color

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

    VBA to delete chart image in Word

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

    Which is the correct syntax to use in this example formula?

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

    Split Range

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

    Formula to check A1 format (General or Date) then return B1 OR C1 depending on A1's formatting?

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

    Conditional formatting

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

    How can split an outage time duration into different segments / ranges

    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...
  13. Johnny Thunder

    VBA Help - Looping thru a list of values and copy/Paste into another workbook and create a .txt file with the new criteria

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

    Excel 2007 formula required

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

    Excel 2007 Automatically Turning on Design Mode When Saving and Exiting

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

    printing problems in excel 2007

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

    Replace part of a text string with the value of another cell

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

    Method to highlight names with consecutive attendance

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

    VBA for hiding columns based on inputted date

    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"...
  20. C

    ActiveX ComboBox - Blank rows and duplicate values

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back