strange

  1. C

    strange result - Nested IF statement

    A B C D E F G H Reporting Date Invoice ID invoice payment id invoice header id invoice terms date vendor number po/non-po flag supplier name 23-Apr-20 1900057573_5430_2020_0001064077 1900057573_5430_2020 0001064077 NON_PO GT TRANSPORT 2012 CO LTD 23-Apr-20...
  2. M

    Strange behavior for Excel 365 when deleting pictures

    I have run across some strange behavior, and am wondering if anyone else has experienced this. I have a worksheet where the user can import pictures via VBA code. I also have a couple of checkboxes (form controls) on that sheet. I have a button that allows the user to clear the sheet of all...
  3. C

    A very Strange ":"

    Dear All, my friend came across a very strange formula, when you imput in any cell=-" :", you get a number:416.666, anyone can tell me why? hope some one can solve my issue. best regards! calvin
  4. jim may

    Anything Look strange with this - using in Office 365 = It is Displaying $0.00 but shouldn't

    <tbody> =SUMPRODUCT((YTD_GOOG_2019_CyberSource!$A$5:$A$500='Monthly Recons-Google'!C$4)*((YTD_GOOG_2019_CyberSource!$M$5:$M$500="Settlement")+(YTD_GOOG_2019_CyberSource!$M$5:$M$500="Card Credit"))*(YTD_GOOG_2019_CyberSource!$I$5:$I$500)) </tbody>
  5. S

    Pattern Not Applying to Cells

    Hey All, So a friend of mine has a workbook that is acting up. When he selects a range to fill the cells he has to click twice. The first time he clicks nothing happens, and the second time he clicks the pattern is applied. I thought this was curious so I recorded a macro when he did this and...
  6. W

    Excel file opens with strange characters

    How can I convert my excel spreadsheet from these strange characters into words and numbers?
  7. P

    Column "E" not unhiding

    Hi all This is very strange. I have hidden columns D, E, and F. When I go to unhide them, Column "E" does not unhide. It is a very large program with many macros. I even tried to unhide column 'E' with a macro but that still did not work. Any thoughts on what is causing the problem? I am...
  8. G

    Index & Match gives strange outcome

    Hello, I tried to do an index match on the same column (the image below is an simplified example). Unfortunately, I tend to get strange outcomes but cannot see why. Only the '4643358' at Q9 seems to be working. The formula I used was: =INDEX($B$2:$B$14,MATCH(P2,$B$2:$B$14)) Anyone got an...
  9. E

    Pivot Table put column side by side

    Hello, I have a problem on my pivot table, when i add several fields in the columns they are display with a strange way. And i would like it to be like this. How can I do ? Thanks.
  10. M

    IF Function strange bug

    Hi all, Iam trying to autofill an Excel and the following code gives a strange fault: ActiveWorkbook.ActiveSheet.Range("T2:T50").FormulaR1C1 = "=IF((RC[-9])>(R[-1]C[-9]), RC[-2], RC[-1]) The formula isn't correct on row 10, 20, 30 and so on because it uses row 1, 2, 3 and so on. Any one of...
  11. RobbieC

    VBA Vlookup to return value LEFT of table

    I posted this up a few minutes ago, but for some reason the post fails when you click on it...I didn't put anything spurious in there...very strange I'm basically able to do a VLOOKUP in VBA using: filetype = Application.WorksheetFunction.VLookup(filename...
  12. B

    i have seen some strange code what is it for?

    a = (Target.Row - 11) / 3 Mya i know what is it for?
  13. H

    VLOOKUP with multiple results RETURNS text if multiple return values...? No vba...

    :eeek: Possible? Trying to get a non-vba solution to have a vlookup return the word "MULTI" if there are multiple RETURN values for a lookup values. Example: <tbody> <tbody> A B C D 1 lookup values Array 2 Holga 小非 9854 3 Doña 3023 4 Doña 3023 5 Holga 2 6 Holga...
  14. S

    Strange behavior in some of my formulas

    Hi guys, I have the strangest behavior in an Excel worksheet I have ever seen. I have uploaded a small portion of my worksheet to my dropbox. https://www.dropbox.com/s/ptm4ie27k3gl0pc/Strange.xlsx?dl=0 Strange behavior 1 The first formula calculates the age from a date of birth. Works fine, no...
  15. C

    Excel changing " to two ' by itself.

    Basically whenever I enter " (quotation 1 symbol) and follow it by a Cyrillic text, Excel automatically changes it to two apostrophes ('' 2 symbols) and my formulas start trowing up errors. It also happens when I edit only the text of a previously working formula, as demonstrated in this short...
  16. C

    Macro acting funny

    Hi, I have a macro that imports a text file, cleans it up, and transfers the information to a printable data sheet for processing. It works great for %99.9 of my users. I have one guy who just transferred from excel '14 to '07 (which is the format my software is formatted for). When he runs...
  17. C

    xlUp not working in For loop

    I have been tasked with debugging some code at work and have found an easy fix for it, but don't understand why it works.. The original code: For x = 6 to Cells(10000, 1).End(xlUp).Row The "repaired" code: last_row = Cells(10000, 1).End(xlUp).Row...
  18. J

    strange currency format behaviour

    My default currency is £. I have a column of numbers formatted to £. the next column is a formula that multiplies the £ column by the exchange rate for Brazilian reais R$. When i format that column to R$ the first column changes the format to £$,that is a pound sign followed by a dollar sign...
  19. T

    Excel behaving strangely

    Just recently when i use excel whichever action i choose ie. highlight column, cell, start formula, flip between sheets, seems to lock the pointer to this function and i can't get out of it. thus i end up highlighting the whole sheet, rows etc. i simply become locked into whatever i have...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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