intended

  1. SanjayGMusafir

    Go to same row by table header

    Hi Experts Right now I'm using VBA that goes to an intended column in the same row. Can there be a way where, it can jump within same row to the intended column by table header name, as I keep adding or removing columns to the table and every time I do so, I have modify so many such vba(s)...
  2. 8

    Sheet1 Not running

    So I have a lot of ComboBox on my sheet1, I cant seem to activate it execpt if I go to sheet2, and then back to Sheet1. Then they function as intended. Is it possible to avoid this process, for it to function properly ??? Thanks in advance
  3. V

    COUNTIF not working for highlighting Triplicates

    Hello, I am using this formula to highlight triplicates or greater: =COUNTIF($A$2:$A$16,A2)>3 However it is not working as intended and this is the result I am getting: https://pasteboard.co/I5fZ0Nt.png
  4. A

    find dates vba problem

    I have the code that is suppose to find all dates older then 3yrs. However I'm confuse as to why is not giving me the intended results. The first code works as expected.... MsgBox WorksheetFunction.CountIf(Range("D15:D100"), "<11/30/2015") However, when I replace the "Hard" date with a...
  5. A

    VBA for conditional formatting

    Dear Excel Community, I currently have a sheet with data resembling this: <colgroup><col><col></colgroup><tbody> Plan Days Intended 13 Unintended 12 Intended 14 Intended 15 Intended 16 Unintended 8 </tbody> As the conditional formatting function does not allow...
  6. A

    Placing A Label Over A Userform Control

    I have a label (label8) that I am trying to position at a certain point of my userform. With .Label8 .Top = 36 .Left = 92 End With The issue I am having, is this move puts the label behind a locked listbox control. This is the intended location, but I'd...
  7. J

    SUMPRODUCT(VLOOKUP(B10:B13,...)) does not work

    The following results in a #VALUE error, even when array-entered, which should not be necessary: =SUMPRODUCT(C10:C13,VLOOKUP(B10:B13,A4:B6,2,0)) The intended interpretation is: C10*VLOOKUP(B10,A4:B6,2,0) + C11*VLOOKUP(B11,A4:B6,2,0) + .... The following work-around does not produce the...
  8. G

    Countifs Index Match formula

    =COUNTIFS(INDEX('location 1'!E7:AI106,MATCH(C6,'location 1'!C7:C106),MATCH($E$3,'location 1'!E3:AI3,0)),"A") I cannot get this formula to work for the purposes intended... See screenshots below... Any help is appreciated!! https://imgur.com/hIvbSHy https://imgur.com/HQSEnXe
  9. Aladin Akyurek

    Who's Online

    behaves now differently. Is this intended?

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