mistake

  1. K

    Spell Check in UserForm

    Hi everyone, Is there a way that I can do a spell check in a UserForm, before the information is sent to the worksheet. I know I can add code to do a spell check after the information is added to the worksheet, but in my case, some of the text will be sent to two different worksheets. Therefore...
  2. N

    Help to correct formula

    Hi all I have two formula but one have result, one have result = 0. I can;t find out the mistake of wrong formula: formula have result =+SUMPRODUCT((('ky1'!$E$2:$E$9999="0101")*(LEFT('ky1'!$A$2:$A$9999;6)="G03654"))*('ky1'!$F$2:$F$9999:'ky1'!$G$2:$G$9999)) formula result = 0...
  3. I

    If the Second Character in A3 is _ then use X formula if not use Y formula

    Sample data set below shows two separate text options within the column if the data has the _ within the cell I need to run a different formula than the ones without a _. And to avoid mistake the _ should only appear in the second character position. <colgroup><col width="65"...
  4. J

    VBA .SpecialCells(xlCellTypeVisible).Copy Function

    My code below keeps error and there isn't any visible mistake, please help.. Thanks wb2.Sheets(1).Range(Trim(Arr2(0)) & FoundCell3 & ":" & Trim(Arr2(UBound(Arr2))) & FoundCell4).SpecialCells(xlCellTypeVisible).Copy
  5. A

    =IF(A1:A10="t","=NOW","")

    What's wrong with this formula? In row A1:A10 if i write t it gives =NOW but not the FORMULA for showing time. What is the mistake here? Thanks!
  6. G

    Changing decimal time to actual hours and minutes

    Hi everyone, I've made an error at work in that I've populated a massive spreadsheet (of times in hours and minutes) by hand, but I used a . instead of a : So for instance: 1 hour and 30 mins says 1.3 7 hours and 48 minutes says 7.48 3 hours and 50 minutes says 3.50 Etc. I can't obviously...
  7. Futile Crush

    Irreparable Error with TRANSPOSE function

    Hey guys, I'm in a bit of a pickle with Excel. I made the dear mistake of succeeding in using the TRANSPOSE function, just to copy 10 rows which I easily could have typed out. But then, I wanted to insert a column, it wouldn't let me, so I decided to take the latter columns out of the equation...

Watch MrExcel Video

This Week's Hot Topics

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
Top