4th

  1. N

    Macro to add 1 to 4th then 5th cell for 200 numbers

    A different number is inputed in cell cd31 every day. Today's number in cd31 is 401 Then I want CD35 to be 402 Then I want CD40 to be 403 Then I want CD44 to be 404 Then I want CD49 to be 405 until last cell: CD926 = 600 Need a macro to increase by 1 every 4th then 5th then 4th then 5th cell...
  2. A

    SumIF date is certain day of month to next month day.

    Hi, This is my code which works for the month but I want it to go from the 4th Sunday to the 4th Sunday of the next month. =SUMIFS($C$14:$C$1000,$A$14:$A$1000,">="&DATE($A$1,8,1),$A$14:$A$1000,"<"&DATE($A$1,9,1),$F$14:$F$1000,$AA1) Thank you AlanS.
  3. A

    Right justify Listbox column

    I have 4-column listbox. Is it possible to right Justify Only the 4th column? Thank you
  4. S

    4th most common text value

    I currently have the following formula to capture the 3rd most common text value from a range. I cant seem to change this in order to capture the 4th most common text value...
  5. E

    replace the 4th letter from the right

    I have a large set of data that contains SKUs with different number of characters. Each SKU can range from 10-20 characters. The only thing that is constant is the last 4 characters. Which formula can i use to only replace the 4th character from the right? Example SKU1-U-101 SKUUU-U-101...
  6. R

    Sum every 4th column

    Hello, I have searched high and low to find a basic formula to add up every 4th column and every formula I have tried has failed. I am trying to add every 4th cell from each column. Example: Add C3+G3+K3+O3, etc. Can anyone provide a formula to do this? The range starts at A3 through BS3. It...
  7. A

    Any Easy way to Split Multiple cells in sheet into separate rows??

    I've inherited an Excel file used for scheduling that has multiple timeslots in one cell - a formatting nightmare! Is there a way to easily split these (like the text to columns) except for rows? Thanks! example row: <tbody> Computer Lab 1 8:00-8:50 open 9:00-9:30 open...
  8. S

    Getting Week As 1st week , 2nd week 3rd week or 4th Week of a particular Date in a month

    Hello How can i get the week defined as 1st week ,2nd week , 3rd week and 4th week of a particular date which falls in Particular Month For eg if i enter 01-Feb-2019 ie in dd-mmm-yyyy then in next adjacent cell to display as 1st Week of Feb 19 14-Jan-2019 to be...
  9. S

    IF formulas working in all but one cell/column

    Hi, I have a budget template that has IF statements to exclude costs bases on the max allowed ($25,000) and the previous years' totals. I have 4 groups of these per year for 6 years and all the IF statements appear to be set up the same and work in all but one of the groups and I can't figure...
  10. MrExcel

    Dynamic Arrays Debut September 24

    Microsoft just announced Dynamic Arrays for Excel. They say that Ctrl+Shift+Enter will not have to be used anymore. It is the 4th item on this page: https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/bringing-ai-to-excel-4-new-features-announced-today-at-ignite/ but I think it is...
  11. Z

    Formula Suggestion

    How do I refine this formula below. =IF(ISBLANK(A2),"",IF(ISBLANK(C2),"",IF(A2<>"",NETWORKDAYS(A2,C2),IF(C2<>"",NETWORKDAYS(A2,C2))))) Is it possible to combine the first and second if arguments and the 3rd and 4th if argument?
  12. R

    Three level ranking

    Hey guys.. Please help me to write a VBa code for the below scenario. I have five columns. First one have names. 3rd, 4th, 4th have criteria. First, give ranking as per 3rd columns, if any output rank have same ranking then it will go to 4th column criteria. If after applying ranking again...
  13. syndee

    Pull cell values from closed workbook in same folder into another file opened from same folder

    I have 4 files in 1 folder. File1, 2, & 3. The 4th file is where I need the data from other workbooks. So, I need data from File 2 from Range A2 to I5000 to populate Range a2 to 5000 in 4th File if cells are not blank. I need this to happen automatically when I open the 4th file without having...
  14. A

    Put value of every 4th cell in above 3 cells

    Dear excel experts. I am in a situation where after exproting some data from old database some vlaues are missing in such a way that cell 1,2,3 and 4 in a column should have same value. but cell 1, 2 and 3 are blank while 4th one has the value. How can i copy the value of every 4th cell in...
  15. V

    Loop formula

    Hello all Can anyone help please on looping this formula, I need to populate every 4th column up to and including column "AW" [With Range("E4:E" & LR) .FormulaR1C1 = "=IF(RC[-2]<=0,"""",1-RC[-2]/RC[-3])" .Value = .Value End With] Any help on this would be great please
  16. R

    paste formula every 4th row dependin on value in Col A

    I’m an occasional user of VBA so knowledge very limited. I have worksheet columns A-G starting at row 4, cell H7contains a formula based on D4 and D7. I need some VBA which identifies whenCol A has a value in A11, A15, etc (every 4th row) and then copiesthe formula from H7 to every 4th row in...
  17. K

    need immediate help

    I need help setting up a spreadsheet that will arrange times, places, and divisions automatically if possible. To explain, each D is different. In a 4D format, The 1D needs to be the quickest time then the 2D is .5 Seconds off the quickest time. The 3D is 1.0 off the quickest time and the 4D is...
  18. K

    3D Barrel Racing Spreadsheet

    I need help setting up a spreadsheet that will arrange times, places, and divisions automatically if possible. To explain, each D is different. In a 4D format, The 1D needs to be the quickest time then the 2D is .5 Seconds off the quickest time. The 3D is 1.0 off the quickest time and the 4D is...
  19. H

    Date Formatting

    I need a formula that writes the current date exactly as below (Using today's date as an example) Dinner - Thursday 4th January 2018 ANY HELP GREATLY APPRECIATED I AM GOING MENTAL HERE LADS :rolleyes::laugh::laugh:
  20. D

    Counting specific values in every 4th row

    Hello I need help in finding the formula to count specific values in every 4th row. For example, I need to count how many numbers "1" are in row 2), 6) and 10) total (in this case result should be "3") Later I need to do the same thing separately for numbers 2...75. Counting how many number...

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