great

  1. L

    Let bloomberg functions old before preceding with the vba

    I just need VBA code that I can put within mine that allows the Bloomberg formulas to load before the rest of the VBA code continues. I've been trying to do this for a while and can't figure it out! Any help would be great!!
  2. D

    Now rounded to the hour

    All, I must be doing something way wrong. I am trying to have something in excel that is =Now(Hour(1)) so I am wanting to round down to the nearest hour. I am sure this is beyond simple but I can not get it. any help would be great. thanks
  3. J

    "MROUND" - Need Min. 0.25 Value

    I am utilizing "MROUND" to round to values of 0.25, 0.50, 0.75 & 1.00 - it works great, but I can't use a "0.00" value (I need min. 0.25) -- what can I do?
  4. J

    A different kind of compare

    Hello, I am working on a project that relies on 2 workers individual reviews of the same movie. There is a concern that some of the second reviews are too similar to the first because the second worker is somehow copying the first workers review. I have about 14 thousand entries to audit and i...
  5. L

    Removing duplicates

    I have a long list of names down column B in which there are duplicates of the name. What I need to do is reduce the list by eliminating the duplicates. Any help will be great. I would upload a file etc but I'm currently on my tablet. Thanks.
  6. D

    INDEX formula not working when transferred to Google Sheets

    Hi all. I've had great success on here and I didn't know where else to ask. I have a simple formula that works great in Excel but when I transfer the document to Google Sheets so I can share it, I get the following message: =IF($E$6:$E$27=1,(INDEX($F$6:$F$27,0,1)),"-") returns #REF!: Array...

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