cancellation

Good day Please assit wt hthe below =IF(B7=0,COUNTIFS(Jan!$R:$R,"*"&A7&"*",Jan!$D:$D,$R$1),COUNTIFS(Jan!$R:$R,"*"&A7&"*",Jan!$D:$D,$R$1)*2) This formula works fine as long as the text A7 does not appear more than oce in a line in column R e.g if R1 = Cancellation R2 = Cancellaton and A7 is the...

I am trying to build out a waterfall that will count how many customers we have based on what time they became a customer. The plan is to count the account IDs if they are new business and remove them if they have been cancelled. The issue is an account can have numerous opportunities marked as...

Hi Guys, I hope you’ll be able to assist me with the below code. I’m trying to build 4 d active dependent Combo Boxes. I got great assistance from one of the forum members here. However, I’m afraid the code works perfectly till “Case 3000”, starting from this case, it doesn’t work...

Hello there! I'm trying to make a spreadsheet that would automatically populate a cancellation effective date. If a product is cancelled on the 10th day of the month or less, than the cancellation effective date should be the last day of the current month. If the cancellation is greater than the...

Hi I have a large spreadsheet that should be used for a construction. To use it for the next construction I have made a macro called "NySag" It selects the area with data for this construction and clears it, then it opens the Save As dialog in order to save the emptied spreadsheet in a new...