opposite

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...

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

<!--[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...

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...

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...

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...

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...