till

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

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%

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

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

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

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

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

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?

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

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.

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.

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 ?

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

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

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

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.

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

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

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

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?