solution

https://ufile.io/ds0xh please how to treat this tables

I need solution for increasing Nested-If limit more that 07 Please help

Hi all, Iam trying to autofill an Excel and the following code gives a strange fault: ActiveWorkbook.ActiveSheet.Range("T2:T50").FormulaR1C1 = "=IF((RC[-9])>(R[-1]C[-9]), RC[-2], RC[-1]) The formula isn't correct on row 10, 20, 30 and so on because it uses row 1, 2, 3 and so on. Any one of...

Hi, I am looking for a way to dynamically change which formula is used depending on the value in another cell, example: <colgroup><col><col></colgroup><tbody> If value is between Use formula 0-40 ROUND 40-100 ROUNDUP 100-1000 ROUND 1000-10000 ROUNDDOWN </tbody> I am looking for a...

Hi, I have a bunch of IF conditions which have given me TRUE or FALSE values. I am trying to combine False values derived to conjoin with another IF statement but I am getting a FALSE value for all the data . For eg <tbody> A B C D E F Combined A-F New Value True False False False False...

Hi, I am looking to use VBA so that I can use autocomplete when using data validation lists, I came across this solution: http://www.contextures.com/xlDataVal10.html which works perfectly for normal validation lists. However when I change my list from a standard list to using an offset...

I have a process that needs to loop through all the files in a SharePoint folder but the scripting.filesystemobject function doesn't work. I'm really struggling to find a solution to this and hopefully someone can give a bit of advice. TIA

After the brilliant solution to my thread https://www.mrexcel.com/forum/excel-questions/1059039-listing-all-values-within-range-values.html (which I am still working out on understanding the code), if there is more than one requirement in the sheet, is this possible?? If Value A, Value B...

Hi I have tried to look up the thread but the solution =IF(ISNUMBER(SEARCH("CR",Cell_Format)),a2*-1,"") doesn't work. Cheers Michael1965

I've created a userform with three text fields, all of which are identical in terms of font and size. When I pull in the text from a worksheet, just one of those fields displays the text you can only view with a microscope. I've checked and rechecked the properties and I can't find anything...

This is a solution. I use a label on a sheet to detect mouse move commands so I can control a shape size. My problem is that even though the label backstyle property is set to invisible, a user can click on it and temporarily cause it to display the backcolor until the mouse is moved from the...

Hello all, This will be easy to most of you, but i spent already more than couple of hours to search for solution, and cannot find correct way to work... Forgive me for being computer-illiterate. I need function for this case: To check value in D7 cell, and if value is only between 0-0.04 or...

I need your help to build a Macro that do this... The problem: <tbody> A B 702 12345 702 VSA 702 6A 12346 CKM CKM 701 12378 701 </tbody> The solution: <tbody> A B 702,VSA 12345 6A, CKM 12346 701 12378 </tbody>

Good evening Mr.Excel first of all I would to thank you for all video and forum that you have upload.\ I have questions regarding filter. how to filter large amount of data using macro when I trying to do macro it keep on pop up with (Too many line continuations) & compiler error what is...

Hi team, I've been searching for weeks on how to complete this task but I can not even get a starting point. All I have managed to do is turn off certain aspects of excel to make the coding run more efficiently. I cant write my own code but I've been able to understand what I find online...

I am looking for help to make the following happen. Say like I have a range that is from A20:C50, how can I make it so if a value in cell lets say cell A5 was "8" my new range would be A28:C50. Ultimately I would like to be able to take the remaining data and copy and paste it into another...

Here's another one that I can't seem to find anywhere. I am not looking for nested validation or dependent drop downs, I know how to do that. Maybe what I want is simpler but I'm just not seeing a solution... I have attached a sample worksheet. What I want is a self-populating list that is...

Hi everyone! First of all, this is a cross post and I am only posting it because although people were helpful on another forum I did not got a solution in the end and would like to ask your help too. You can find the original thread here and can post you answers there or I can add the solution...

Hello All, My first post after searching for a few days for a solution. I have an internal work web page (I know, trouble from the start...) in which I need to click a button. (yes, search is spelt incorrectly) I have tried many methods but can't get a solution. like these...

Hello everyone , i have been trying to find a solution for my problem but it is really wierd because i found no solution. so here is my problem : i have a whole column in which every cell have a Data validation list. So in Vba i am making a For loop to compare the value selected in those cells...