1. M

    User form Date Field Mask or Template

    Hi, I would like a user form date input field where "dummy" characters appear in the field when field is selected i.e. dd/mm/yyyy. These characters should be greyed out. When the user starts input to the field, input would overwrite the "dummy", in black. My attempts up to now have resulted in...
  2. S

    Dummy question - how to hide data?

    Hello all! Apologies in advance for the dummy question. This is myfirst dip into Excel since school and despite scouring the internet for theformula I need, I can’t make Excel do what I want. So, I have a table that when I insert a date in column C Iwant it to show the date + either 30 or...
  3. N

    a little odd: Need to convert TODAY() date to two digits 0000 and use 2 letters + 6 random number formula

    Hello, I'm breaking my head here, I understand a little =Tex which changes my TODAY() cell in another cell to 0406. Now I would like to add initials at the front like CS0406 followed by 6 random numbers. CS0406123456- It's killing me, can someone help? It doesn't have to pull the date from the...
  4. M

    Excel Macro Question

    Hello everybody, I did some digging around the forum and couldn't find anything pertaining to my question. I have a macro that performs a huge of amount of maintenance on a particular file. However, because nothing is easy, the one of the worksheets will be missing a certain column under...
  5. M


    Hello All! I can't remember how to utilize percentages in Excel. For example, I have 10 dummy clients, 2 dummy clients have viral load results equal to or less than 20.... I know basic math would be 2/10 * 100 = 20 (20%) So I Excel, I entered this in a cell: =2/10*100 And I got 20...
  6. D

    Search multiple values, index next column (create a dummy for serch and paste loop)

    Hello, I am trying to index values defined by a search from values in a third column. Tried with vlookup, but it did not work, dont know why. So now am trying with macros. Here where I got without the loop: Sub bb() ' ' bb Macro ' ' Selection.Copy 'THIS IS THE SEARCH VALUE, STARTING AT C1'...
  7. L

    help interpreting regression results with dummy variables

    So I ran a regression on different "type" scenarios and got the following. I see that the R-Square is not a great fit (<95%) but I was hoping I might be able to use this regression to figure out some relationships and make some determinations about which "Type" would yield the best results. In...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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