matter

Hi All I have a simple sheet formula that looks like this. =CONCAT(J2+G2+D2/A2*100;" %") Value in J2=0 Value in G2=3 Value in D2=1 Values in A2=52 The result ends up being 4,92307692307692% which is way to many decimals no matter what i try i cannot get it down 4,92 without an error. Hope...

im trying to delete all duplicates based on an ID in column F, except one (it doesn't matter which one I keep...ie it could be the first one, could be the last duplicate). trying to do this with a macro.

https://1drv.ms/x/s!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc) (Purpose is so that I can do YTD calculations using the output)

Hi all, I have failed in trying to find this information via searches on this forum and Google so here are my questions. Using VBA MS Office 2011 for Mac: Can you hide the title bar? Is it possible to get a picture to be inserted into a userform? No matter what size or format I try I keep...

i have a sheet that has a dropdown list of names, when i select a name a table comes up and boxes are coloured in based on conditional formatting. when i add a comment the usual way it remains there no matter what name i have selected from the dropdown list, when i only want it to be there in...

I have several hundred workbooks that the Identification number is in various cells between H2 and P4. In cell AI1 would like a formula that will get the Identification Number no matter what cell it is in between H2 and P4 Thanks in advance

I am finding the differences between adjacent numbers in a column. All have been verified by ISNUMBER enquiry. The answer is always 0, no matter the format of the answer cell. Please! Why this happening and what's the solution?

I set up my conditional formatting to turn text green if equal to or less than 5.25 and red if greater than 5.25. No matter what number shows up in the cell, they are always green. This cell is a percentage if that matters. I went to another cell to test it on a simple one, but not a...

I have a multipage with a label on page 1. I want the label to reflect what is in cell B5, but it doesn't do anything no matter what I try. Any ideas? Private Sub FeesForm_Initialize() Dim ws As Worksheet MultiPage1.pgTerm1.lblTerm.Caption = ws.Cells("b5") End Sub

Ok So I have checkboxes I use in If statements thorughout my workbook and after adding one final it seems no matter what I do it will not recognize the value I have declare the variable for the checkbox as normal Dim RnFinalCB As CheckBox: Set RnFinalCB =...

Morning all, I'm using For Each cell in a particular column. If this value is greater than zero I need to pull in the value from column A. But the column I'm currently in will change based on which month it is. How do I return the value from Column A no matter what column I'm in. ie. if I was...

Many questions: 1) Does this option behave differently in different versions of Excel? 2) Does it matter whether it is on Window 7 or Windows 7 or should it behave the same on both 3) Microsoft Help only explains the feature but offers no assistance on how to permanently deselect it by using...

Something has gone wrongwith my sheet,,,,,when I type =k8 and press enter all that happens is =k8 shows in the cell not what is in k8 no matter what is in k8, and it seems it is doing it in all the column. Any help with this please?. Len

I know this is probably easy, but I haven't been able to make it work. This is what I'm trying to do: If Cell M2 contains a certain string of Characters, I want it to return "Fund" if it does, and "Ad Hoc" if it doesn't. I've got it to where it will return Ad Hoc for everything but can't get...

Hi, I was looking for some help. I have a row of numbers and would like to conditional format them so that the 2 lowest values are highlighted. Example: 13 15 8 10 12 8 5 9 In the above example, I would want the 5 and either of the 8's highlighted. Doesn't matter which 8...

Hi In this article https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas MS define SaveAs as a method!! While object browser in VBA editor define it as Sub? Which one is the correct one? or it does not matter? Thank you very much.

I have set up sheets that are created in pairs for example sheet names 0024A and 0024B, I want to have a generic equation that will reference the other sheet. I can get the other sheet name by using: =LEFT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),4) & "A" but when I add on...

I.m running XP and updated my Office a couple of days ago. Ever since I've had to uninstall an Update (KB4462157) each day or it won't load. From Googling it seems I have to turn off Automatic Updates. Can this be done for Office/Excel or must it be Global for the whole computer. I don;'t think...

I just cannot seem to get this right today. I'm trying this: =IF(AND(E4=0,D4>0)*OR(C4>D2),"New",IF(AND(E4>500,D4>500),"Mature","Winding Down")) Not giving me what I want. I want if E4=0 and D4>0 or if C4>D2 to give me "New". If E4>500 and D4> 500 give me "Mature" otherwise "winding down"...

I have entered a data validiation condition in cell A1 with options "Yes" and "No". In cell B2 i want the outcome as follows: On selecting "Yes" option in A1, the value in cell B2 is automatically changed to 100% On selecting "No" option in A1, no change takes place in cell B2 and the user...