change

  1. R

    Delete rows if cell value is greater than a specific time

    Hello again! Hopefully, today was a pleasant day for everyone. Not a perfect one, necessarily, but at least a pleasant one. :) I thought this would be an easy thing to find, but I can't seem to find any code that will do what I need. My spreadsheet is only 7 columns by about 300 or 400...
  2. S

    Conditional format based on various cells

    Could anyone please advise on conditional formatting? I'm trying to use a formula to have say cell a1 to change colour IF cell d1 has any input? I've been trying conditional formatting in cell a1 as - If(d1="",TRUE,FALSE) but no change happens with input to cell d1. Any help would be greatly...
  3. G

    If formula to return a different value if a cell has 0 or is blank

    Hi experts, I am new to the site, so I apologize if I have posted this in the incorrect area. In the below table I have the following formula in C3-C5, =IF(B3=1,$D$2,IF(B3=2,$E$2,IF(B3=3,$F$2,IF(B3=4,$G$2)))) <tbody> A1 B C D E F G 2 Start Pause Re-set Stop 3 1 Start...
  4. N

    How to change dynamically excel external file name change daily as the date

    Hi all, I am a beginner to this technology VBA Excel. I faced a problem in the project Read an external file and look for a Specific String (This external file name will change daily – as the Date – which will be part of the file name – will be dynamic) Return a Value from the 8th Column...
  5. C

    Link in Formula

    Hi, I'm using index match reference, but I have to change every formula one by one, is there a faster way? https://ibb.co/X2pcKzP See the photo attached, I have to change the formula in G56 from '[7 July Shop Yields.xlsx]1.7' to '[7 July Shop Yields.xlsx]2.7'! manually but whereby F56 already...
  6. S

    Change the order of DAX tables

    Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks
  7. J

    Change format of userform textbox to currency

    Hi there, I have a userform with 4 textboxes that when text is entered they all refer back to individual cells. All data entered on a spreadsheet goes to the userform and when entered into the userform goes back to the spreadsheet. One of the textboxes displays a price but i cant seem to change...
  8. B

    Change row colour for complete tasks

    I want to change the colour of the row to green when my 'project status' is inputted at 100%. Is there a way I can do this?
  9. D

    VBA Change Header Font Size and Text

    Greetings Can the below VBA string be modified to add the word "Date:" before the actual date, and change the font to Ariel 12 point bold? I'm using MS Office Professional 2013 and Windows 10 Enterprise. RightHeader = Format(Date, "dd-mmm-yy") & Chr(10) & "Page: &P of:&P" As an example, the...
  10. B

    formatting a date

    Hello, I imported a CSV file into a query format and my date column is showing as this right now: 2019-08-28 03:32:31 EDT is there a way I can change that to read 8/28/2019? when I change format to date it does nothing. I can do a formula to pull the left numbers, middle and right but I'm...
  11. S

    How to analyse correlations?

    Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this? What I've tried so far is creating pivot tables and grouping by Production year, Category...
  12. A

    Combo box Change Event twice

    When I make a selection using the drop down arrow, the change event executes once. However, if I type 1 character, the change event execute twice. I step through the procedure and I can see the code only execute once until to the end of the procedure and then my cursor changes to a wait circle...
  13. S

    change column headings to inches

    Hi i'm using 365 I sort a remember that in older versions of excel, I was able to change the A,B,C, and the 1,2,3,to inches. Was I dreaming? I'm trying to make a business card and i don't want to keep changing the fonts and printing them till i get the size right. mike
  14. C

    Add month formula but without day or year

    So I have a spreadsheet that I have a drop down for the month of the data, when I change this month then I want the cell in my next table to increase y 1 month. In other words if I select June on B2 then I want K2 to change to July. I have tried a few different formulas but I am failing. Here...
  15. D

    How to change "dates" to clean data

    https://1drv.ms/x/s!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc) (Purpose is so that I can do YTD calculations using the output)
  16. M

    Change SumIf range when copied across

    Hi i have a simple sumif formula in B2:B11 that is = SumIfs(tel!$J$2:$J$11,tel!$A$2:$A$11,$A2) What i need to is when i copy the formulas across to C2:C11 I need to move these ranges down 5 rows down from the end so this tel!$J$2:$J$11 to tel!$J$16:$J$25 tel!$A$2:$A$11 to tel!$A$16:$A$25...
  17. J

    Using autofill on cells with formulas

    Is there a way. . . I am in Cell A1 and the formula is =E1. I want to copy my formula down but instead of the row # changing from E1, E2, E3, etc. I need the COLUMN to change from E1, F1, G1, H1, etc. Is this possible?
  18. C

    Excel Header and Footers

    I have an excel workbook with 6 worksheets. Each worksheet has a different header. Each week, I want to be able to change 4 of the worksheets footers without changing their headers. When I group the 4 worksheets and change the footer; it changes the headers too. Is there a way to change 4 of...
  19. R

    keyboard Shortcut for the ½ character

    Hi I have some tedious data entry to do into a spreadsheet. Mostly text. Every once in a while I have to use the 1/2 character in a string So I can copy and paste the character from the clipboard (very quick) but copy/paste gets used a lot anyway so then I have - to stop typing. go find 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
Back
Top