solution

I have a complicated UDF that takes several ranges as parameters. Each of these ranges can have up to 30-40 values. Each of these values must conform to certain limits, which vary depending on the values in the corresponding cells in the other ranges. The UDF does extensive validity checking to...

I am wiorking with a sheet that is foramted as a table. I have tried five separate codes to get the last row in column ag. None work. Can anyone suggest a solution? https://www.thespreadsheetguru.com/blog/2014/7/7/5-different-ways-to-find-the-last-row-or-last-column-using-vba

Hi, I have a problem with table below. I need to learn what formula to use so that I can get correct answer to Solution X. I added into the table what I need for answer into Solution X column. User1, Info2-3 varies depending if users fill it or not. Solution X needs to be same in all lines...

Greetings, As a policy in other forums, I am posting the same thread below perhaps you have a proper solution for the query https://www.excelforum.com/excel-programming-vba-macros/1268754-duration-countdown-single-input.html#post5084896 ThanksGreetings, As a policy in other forums, I am...

I've Googled a solution to what I would believe to be an easy problem, but was unable to find anything similar to my situation. I have a range E2:E15. What VBA solution would I use to return the row number of the last cell in that range that holds a value?

I'm trying to find a method to identify if a specific module exists in a project. I've tried this but it doesn't work - is there a simple solution? If ActiveWorkbook.VBProject.VBComponents("Setup") <> "" Then

Hi, I know this must be a simple answer, I have the following cell D5 = A5, and E5 = A6. I want to be able to drag these down so D6 = A7 and E6 = A8 and so on down. Obviously i am dragging and getting D6 = A6 and E6 = A7. what is the solution? Thanks J

Hi everyone, I'm looking for help with a solution to generate all possible combinations of a set of data, and have these combinations shown in separate columns. Small example: <tbody> a 1 z & a 1 z & b 2 y a 1 y & c x a 1 x & a 2 z & etc etc etc etc...

Hello all and thank you in advance for any advice. Microsoft 2016 I have dates listed in and based on how far away the date is from today in decimal forum I need to add 2 cells together. As an example, if the item x is 6 months from now, I need to add a cell to the price shown therefore...

I have cell A1 which has string: -18 -11 -15 -8 -2 -5 -20 -14 -10 -7 0 -13 -19 -4 -1 -12 -6 -3 -9 I need to sort this string to be like: 0 -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 -14 -15 -16 -17 -18 -19 -20 Or string: 18 11 15 8 2 5 20 14 10 7 0 13 19 4 1 12 6 3 9 To be like 0 1 2 3 4 5 6 7...

I did find a thread that came close to my solution... but not quite :-\ I have two columns K and L. If L is blank use the value of K. That worked out just fine with: =IF(L40="", K40,L40) My question is how to add an additional condition of: IF K40 is also blank THEN type "Unassigned". It...

I have dates that are formatted a: 1012019 1022019 4012018 What I need to do is to take those dates and minus 1 from them: 1012019 = 12312018 1022019 = 1012019 4012018 = 3312018 I have a formula that I figured out below (It works but do not know if it the best solution)...

Would you please explain what is the Excel calculating 8 processor(8)? My spreadsheet is talking a long time to open up and inserting rows and column. Does it make any difference whether I save the workbook in xls or xls files. is there any solution to make my workbooks faster to open up? Thank...

I have rather large textbox where a user can type notes and use the return key for spacing, etc. textbox1.value is (example) 1. Problem1. Solution is blah blah blah. 2. Problem 2. Solution is blah blaha blah. 3.etc 4.etc 5.etc The question is how I can parse this line by line to my...

Hi all, I thought this would be a relatively easy conditional format to apply however i'm really struggling to find a solution. In brief I would like to apply a conditional format to highlight cell A1, if any of the cells in range, say A2:A100, contain any text. (A2:A100 should only contain...

Hi all, I have been racking my head, searching the wonderful world of Google and haven't had any luck finding a solution to my dilemma. Is there a way to filter a query where a specific date field is >=90 and <365 of today's date? Since my dates in the specific field are "Live" (changing every...

Hi, I would like to delete rows in which the values in Col C thru G are all "0". Is there best VBA solution? Thanks in advance, Mikel

Hello, I am trying to work out if this is possible, cantfind when googling but might be using the wrong terminology. I have the following workbook set up, what I want toautomate is, for excel to calculate the week num and then filter the columncontaining that value. , so in theexample below...

Hello all you MrExcel experts This concerns my posting #5 & #6 in a thread started by Hitbid called ‘Question about optimizing simple code’ dated Nov. 3, 2018. The link to this is: https://www.mrexcel.com/forum/excel-questions/1076409-question-about-optimizing-simple-code.html I had offered...

I have issue in count cells which I hope you can suggest a solution for. I have column with a mix of 0s and value >0. So I need to count number of zeros in between each number>0 and state it on the next column. It looks like this and what I want to achieve: 1 0 0 0 0 12 count= 4 0 0 0 3...