opposite

  1. G

    Formula Opposite of DAYS360?

    Hi all, I'm curious if there's a formula to do the opposite of DAYS360. That is, DAYS360 figures out the number of days between two dates on a 360 day basis. I want to make a formula that adds a number of days on a 360 day basis. So if my starting date is 5/25/19 and I add 6 days, it should...
  2. D

    Togglebutton as Option

    I have Excel Sht. Has Ribbon 6 Togglebuttons I need when Press ="True" One of then the other get opposite Press="False" Thx
  3. N

    Opposite of Conditional Formatting

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Dear All, I am looking for some formula/ process in excel that is opposite of Conditional Formatting. I mean Conditional formatting is that If I have some value X in a cell...
  4. JenniferMurphy

    Speeding up a UDF

    I have a complicated UDF that makes hundreds of updates to the data on the screen. It takes 10-15 seconds to complete, depending on what else the machine is doing. I've seen websites that recommend adding code to such UDFs to speed them up, such as <code>Application.ScreenUpdating = False...
  5. B

    stacked bar vs. legend order in power view

    I have a stacked bar chart in Power View with 3 elements. The challenge that I am having is that the bars are stacking opposite the legend and I would like them to match. This is how it looks now - <tbody> Bar Legend Point A Point C Point B Point B Point C Point A </tbody> I have...
  6. P

    Deleting rows

    Hi, I would like to delete any two rows in my data with: 1. Matching cells in column B 2. Equal but opposite cells in another column C <tbody> Row Source Value 1 S12345678A -100 2 S12345678B 500 3 S12345678A 100 4 S12345678C 300 5 S12345678A -100 6 S12345678B...
  7. N

    Macro to delete rows that contain values of exact but opposite value

    Hi, I am looking for a macro to delete rows where there is another row in the worksheet that has the exact same value but is opposite Eg. Column 1 Column 2 Column 3 Date Description Amount 01/01/2013 Deposit $100.00...

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