thinks

  1. A

    How do I fix this error (excel thinks two different values are the same)

    This is messing my entire spreadsheet up. I have two invoice numbers: 1: 4189032830052819 2: 4189032830052818 they differ by one number (representing the year but that's irrelevant) if I go: Countif(A1:A2,A1) the result I get is 2, even though A1 only exists once. similarly if I do...
  2. Emerlin

    Parentheses character causes Vlookup fail - standard character set?

    Hi, I have a Vlookup the fails because it appears that Excel thinks the () are different characters. Is there anyway to handle this? Thanks.
  3. D

    Help with Selection Count vba

    Hi, I am trying to set if statements so that only more than 1 column can be selected before the code runs, However I am having trouble with if the cells selected are more than 1 as it thinks the columns have been selected. Is there a way round this? If Selection.Cells.Count = 1 Then Exit...

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