till

  1. kelly mort

    Add non continous cells in a row to last used row

    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?
  2. apgmin

    If and countif

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

    Enter number in Textbox till 150

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

    How to extract values between different caracteres ?

    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) ...
  5. A

    Macro which will do some activity till the time I want

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

    Macro selection, last row + resize + select till 2nd line

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

    VBA Code to use output of 1st iteration in 2nd iteration till reaching optimum solution

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

    Automatic portfolio maker

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

    VB to Count till Change

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

    Calculate bi-weekly weeknumbers

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

    Wait for powershell script for to finish it's execution

    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 ?
  12. G

    Deleting rows on multiple sheet

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

    vlookup help on 2 sheets

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

    Probabilities...

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

    Need to sum values till sum is 1

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

    vba help: footer with count of rows in the page.

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

    If, and, vlook up?

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

    if Specific cell contains specific text then copy paste value from cell x to cell y

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

    Vba code to give borders to cell

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

    Multiple Start End Dates Overlapping Count Days

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

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