matter

  1. J

    Concat and decimal reduction

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

    delete all duplicates except one

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

    How to change "dates" to clean data

    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)
  4. TAPS_MikeDion

    VBA: MS Office 2011 for Mac

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

    cell comments on changing sheet

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

    get value from cell in a range

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

    Larger minus smaller equals 0

    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?
  8. D

    Conditional Formatting Not Working

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

    Dynamically Changing Multipage Label Caption

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

    Excel VBA Checkbox..... Pulling my hair out

    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 =...
  11. AndrewMB

    Returning the value from Column A

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

    MS Excel>Options>Advanced>When calculating This Workbook: Permanently Deselect Update Links to OtherDocuments

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

    problem trying to = cell

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

    If Thens

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

    Conditional Formatting question

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

    is Workbook.SaveAs a method or sub?

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

    Reference a sheet based off current sheet name

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

    Updates

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

    IF AND OR combo

    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"...
  20. I

    Data Validation

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

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