compared

  1. M

    Flashing Columns

    Sir, In one sheet I have following 4 range for eg: In range A3:A10 I have certain value and In range B3:B10 there is data. I want a macro that flashes the cell in green if any value in range B3:B10 increases from corresponding value in range A3:A10 and in red in it decreases as compared to...
  2. B

    Excel Perforamnce Issues

    Has anyone else noticed that offi efor excel is vastly slower and more unstable than 2013/2010. I have multiple users that are experiencing lock ups, hanging and even white screens after moving from 2013 to 365. Some of these issues have been resolved in build 1807 compared to the dreadful state...
  3. Welsh Mark3

    Formula to calculation text string similarities

    I've been researching for a formula to give me a score of similarities between cell a2 and b2? There are no exact matches in my data, case sensitivity is not an issue. I see many macros/VBA but I don't have any experience in using these. Is it possible to create the 'Levenshtein distance'...
    • Welsh Mark3
    • Thread
    • abc calculation compared formula issue macros/vba similar similarities text
    • Replies: 7
    • Forum: Excel Questions
  4. Y

    Indirect formula not working

    Maybe I'm not seeing clear, but I can't see what's wrong with my formula...: =INDIRECT("'"&AZ13&"["&$D8&" "&$H8&" "&$F8&".xlsx"&"]Budget Summary Conv to USD'!$AD$"&IF($D8="P90","82","130"),TRUE) I tried removing the quotes in 82 and 130, it doesn't work either way. I even compared the result...

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