till

  1. M

    Nested If in VBA Macro

    Hi Could you please help me to fix the below formula in column and its drop down (by increase cell count) till the last row in the VBA Macro =IF(C2<2,"0-1 Days",IF(C2<3,"1-2 Days",IF(C2<4,"2-3 Days",IF(C2<6,"3-5 Days",">5 Days")))) at the drop downing Column C has to increase...
  2. Z

    equation

    Hello, i would like to know what equation to use if i want to use the below condition if the result is 0% or in negative % then score is 0% and if result between 1% to 25% then score is 25% and so on till i reach score 76% till 100% then score is 100%
  3. M

    Sum values till reach sum total 8 and re sum till sum total 8 again and again

    Hello,</SPAN></SPAN> I need a formula of a VBA that can sum data of column E in the column F when sum reach at 8 restart sum to total 8 again and again. </SPAN></SPAN> Result sample...</SPAN></SPAN> Book1EFG12345DataSumProcedure655Start Sum716806906100611171218End Sum1355Restart Sum...
  4. P

    VBA subtract from next column above cell

    <tbody> A B c 5000 1 300 4700 2 500 4200 3 600 3600 </tbody> Hi Team, I have a sheet like above. I need to subtract B2 from c1, B3 from C2, B4 from C3 till last row of B. Need a vba code. Can some one help me on this.
  5. H

    VBA - If Target Not Intersect Till Last Row

    Hi All, I am using the range A4:A100 since I do not know how to change it to look from A4 till the last row. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("A4:A100")) Is Nothing Then Call Macro1 End If End...
  6. S

    TextJoin copy formula all the way down to existing values on left automatically

    Hey..... I'm recording a macro with =TEXTJOIN(",",TRUE,A1:B1) and the result is correct in C1. Then I double-click and get the results all the way down till there is no more data. Then I stop macro. I look at the vba code and the range is set to that particular macro. Problem is when I use the...
  7. Olaf Jacobs

    Split numbers from letters in row and count

    Hi all, I'm searching for some formula/vba kind of coding to filter information given in an row. The row is setup to represent an year and for each day (represented by single cell) there will be an short little bit of information given an letter to refer to an project and an number 0 till 24...
  8. D

    How to hide

    I have a spread sheet with several formulas when the formula is not being used the cell displays #value ... how can i hide this till a value is added?
  9. V

    Difficult one..

    Hi you all, Because i cannot insert a sample document, i will try to explain my problem.. Suppose you have an Excel sheet. In column A (from A1 till A20) you have text and number data (A1= Option 1, A2 = Option 2, ...). In column B you put 20 drop-down lists that refer to column A. So if you...
  10. Y

    Hide rows

    Hello, i have a table which contains a column for years from 2014 - 2016,showing only year no month no date and cells format is General . I need a formula to hide the rows containing year in future ( 2020 till 2026 ) when its year 2020 that row should be unhidden and so on. Thanks in advance.
  11. D

    macro crashes

    it's a simple macro that simply opens a workbook then copy and pastes to the spreadsheet if i just run it, it often crashes...but if I run it step by step till the end, it's fine. it's driving me insane.
  12. T

    Counting till the current value

    I want to count till the current cell and I used the following formula: In cell K61(Row 61), I entered COUNTIF(B5:B61, "<>C") There are over a thousand such cells where I need this formula. If I copy & paste the formula onto other cells the range changes. What to do ?
  13. M

    Excel VBA help

    Hi, I am not sure how to accomplish the following, hope you can help. I have a spreadsheet named "Upload" and on column "I" I have a string of data (Variable rows). I want to look at the first 4 numbers on that string and if it's greater than or = 4000, then type in cell on the left "Expense" or...
  14. D

    Multiple Subtotals using VBA

    <tbody> Sr Column A Column B Column C 1 L1 5 2 L1 1 3 L2 6 4 L1 2 5 L2 2 6 L3 8 7 L1 3 8 L1 2 9 L2 5 10 L2 2 11 L3 7 12 L4 15 13 L1 2 14 L1 3 15 L2 5 16 L3 5 17 L4 5 18 L5 20 19...
  15. R

    FormulaLocal resulting in 1004 Run-time Error

    I've been following Andrew Gould's VBA Introduction video series on YouTube and everything was running fine up till episode 11.2 - Application.InputBox I type in Andrew's code letter-for-letter, you may compare it e.g. https://youtu.be/NvGv1n4TW28?t=1144 So when I type in the code I get 1004...
  16. W

    Auto Fill emtpy cell till next value with VBA

    Hi Is there a code to do the following? Before A B C D x x x x x x x x x x x x E F G H x x x x x x x x I J K L xx x x After A B C D A B C D A B C D A B C D E F G H E F G H E F G H I J K L I J K L I wan to fill the "x" which are empty.
  17. K

    Need ideas to get column exact totals.

    Hello guys. I have made a sheet preparing payslips for emloyee however I am adding a rule to see if the employees is a Director then the calculations in each columns are done on cumulative basis. i.e. every employee has monthly LEL(1a) = 6032/12=503, LEL-PT(1b) = 2392/12=199 and PP-UEL(1c)=...
  18. S

    CountRows with upper bound

    Hey guys, I need ur help plz Does anyone know if there is an excel function that counts the number of occurrences in a row of some value till there is a new value For example: The value The occurrrence counter 4123 1 4123 2 4123 3 4111 1...
  19. G

    How to automatic my INDEX and Match

    how to automate this formula because i need to encode this till cell ATS,ATT,ATU my formula for cell are: cell cq my formula is this : {=INDEX(Form!$D$2:$D$10115,MATCH(Calc!$B$24&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))} cell cr my formula is this : =VLOOKUP($B$24,Load!$B:$D,3,0) cell...
  20. B

    Cut Row and cells below and paste into new sheet if tab certain color

    Hello, Im trying to run a macro that will make multiple sheets. I want it to cut any cell that is say "blue" and anything beneath it till another blue cell into another sheet based on the text in the first blue cell. Any ideas?

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