till

Hi, I am adding F7, H7, J7, L7 and N7 into S7 . Then go down to S8 and do same addition till I get to the last used cell in column A . Can someone help me with a vba script?

Please help me with this!! =IF(AND(COUNTIF(AM2:AT2,">1")>0,I2>0),"MODULES REATTEMPTED","PASSED IN FIRST ATTEMPT") the above is the formula I have used but it is not working I want the formula to first check if I2 is zero or greater than zero If it is zero or empty it should not display anything...

Hi All, Anyone knows, this..I want to enter number only in textbox till 150. After 150 it wont except.

Hi. At link below I have attached a excel file where I am trying to extract the data number (day-month-year) from 3 different texts and with different lenghts, but with no sucess till now. I have included more details on excel file. I need the formula (not VBA) ...

Hi, I need a macro that will run till the time I want. Basically in my organisation I need to show productivity on excel. So I need some macro that will keep performing some simple calculation and can run for the time I want. And also it should be closed once I want. Please help me with this.

Hi guys, i'm working in a macro in wich it should delet all the actives cells between column "A" till column "AF" without deleting the the 1st line and the rest of the columnos form AF to the right. Sub Process1() ' ' Process1 Macro ' Range("A" & Rows.Count).End(xlUp).Select...

Hi all, I am trying to do genetic algorithm in excel and the 1st trail will result in a recommendation by saying replace parent 1 by child 2 for example. the question is how can i code that in excel, so it will replace parent 1 by child 2 and do another iteration etc, till i reach a number of...

Hi, At the moment I'm writing on my thesis which is about Return and Reversal. To do this I need to construct a lot of portfolio's. At the moment I have 1100 stocks which I need to evaluate. As you can see from column A to C I have the different companies who where in the S&P 500 and from when...

I don't do much with VB and need some help to count/tally up the number of instances of a given value. Data is sorted by the value so all results are together just need a ongoing count till value changes or cell is blank Value, Expected Result 23589, 1 23589, 2 23589, 3 23599, 1 23599, 2

For an excel, i need to automatically calculate the bi-weekly numbers. So for 2018, up till 5 January 2018 is week #1 , from 6 till 19 January is week #2 , from 20 Jan till 2 Feb is week #3 . With the formula WEEKNUM i only get the real weeknumbers. Is there an easy formula to do this, or do i...

Hi Friends, I have called a powershell script in my vba code using "Call shell (..........". I want to wait till it finishes it's execution.How can I do that ?

Hi everyone, I am trying without results to remove rows on multiple sheet. First sheet is called FR, second is called IT and third is called ES. I need to delete for each sheet, all the rows that have in column F (from F3 till the end of the table) a date before today. Can you please help...

i am build a rpg character sheet and need to validate 2 sheets and rerun a value form bases on vlookup base code so far =VLOOKUP(B46,weapons,2,FALSE) then =IF(ISNA(VLOOKUP(U24,skillstable,{3,4},TRUE)),"",SUMPRODUCT(VLOOKUP(U24,skillstable,{3,4},TRUE))) what this need to do is when my player...

Hello everyone, I have a list from A to Z, what I want to do is to make a probability list of two alphabets, like AA, AB, AC when A series finishe I need to make B list then C, D till Z, all sets will be made in same colum after finishing previous alphbet sets... what formula will work here...

Hi , I have a set of numbers and I want to get the sum till it is 1 and then again sum . A- 0.2 ,0.3 ,0.5 .0.1 -- 0.2 ,0.3 , 0.5 ,1 Sum when it is less than .5 till it is 1 Please help

Hi, how to print number of rows in each page in footer. second page should have total number of rows till second page and third page should have total number of rows till then and so on. how can i do this. should there be a vba macro or can we do this by simply calling a cell reference in...

Raw Data below: I need to create a report that shows: Till ID, Sales Person and Time of first sale. I have used MID to extract the till number and then used IF(AND ..... If till number = 1629 and Column C = sales then return time in column B but this has failed miserably. I want to show that...

I am very new to coding need help with the code," Sorry for my mistakes its my first post" I am trying to copy data from Cell E8 to Cell AB8 if Cell T8 has Yes and if T8 has no the want to copy E8 to AC8 and want it to do the same thing for T9,T10,T11 till T108. I have this Successfully working...

I would like to have a vba code so as to add borders from active cell to left till first column and upwards till first row.

Hello, I couldn't make it happens so far so I decided to get your help in order to find formula to do the job automatically. below table is displaying all the delays for a service in days so I want to calculate the stoppable days excluding overlap days. by calculating it manual: Total days...