assume

Hi, part of my job is to put dates to documents that were made in the past 15 days or so, and I'd like to know if there's a way to put, for example, if today is 08/10/2019, then I'd put a 4 and it should assume that I want to put 04/10/2019, or a 26 and it should assume that is 26/09/2019 (from...

Hey all, I have a conundrum. I have a list of dates where I have received calls at my job. I can get 10-30 calls a day. I am looking for a formula to tell me how many Mondays, tuesdays, etc I have taken calls. I can't assume that i am working every monday between 2 dates cause I do have time...

Hi I am struggling to work out a formula for the below scenario: In Column A1 123 456 789 In Column B1 I am looking to copy the value in A1, filling in the blanks with the same value until a new value is reached in A1. The Ideal result would be in B1 123 123 123 123 456 456 456 456...

Hi I have 2 lots of code that I need to combine to give a result, but it is beyond my skill to do it. I assume it will be using OR somehow, but just not 100% exactly how to do it. =IF(AND(G1256="LOST",F1256<=10),95,0) =IF(AND(G1256="WIN",F1256<=10),-100*F1256+100,0) Both sections seem to work...

Hi all, Good day for you all....... I run this code get run-time error "1004" Autofiter method of range class failed Public Sub MyFilter() Dim lngStart As Long, lngEnd As Long lngStart = Range("m1").Value 'assume this is the start date lngEnd = Range("m2").Value 'assume this is...

Hi, I have some formulas the reference a value on another sheet for a name. I cannot use ctrl-F to find the name on the formula sheet because I assume it sees the formula and no the displayed value. Any workaround to search the values? Thanks

Hi, I have values in cells A1 to A100 A value may look like =1234-4561+456-123 or =456+987 Or even 1234 My aim here is to give each individual value it's own cell So assume my first example is in A1 then my aim is for B1 = 1234 C1 -4561, etc. Any help given would be gratefully...

I am using a sumif array formula: =SUM(SUMIFS($T$6:$T$3000,$D$6:$D$3000,$B3,$B$6:$B$3000,"Y",$BJ$6:$BJ$3000,{"1,2,3","1,3","2,3",3})) this adds items that have = {"1,2,3","1,3","2,3",3} these different combinations. I realized there is also another option I must consider "2*,3" however when I...

Hi Guys I have set up a dropdown box that allows me to select for 4 criteria-Construction, age, size,condition ( see Yellow coloured headings). Under the heading-Construction there are four selections- Double Brick, Brick Veneer,Weatherboard,Fibrous Cement. The selection that I have made from...

Hi Guys I have set up a dropdown box that allows me to select for 4 criteria-Construction, age, size,condition ( see Yellow coloured headings). Under the heading-Construction there are four selections- Double Brick, Brick Veneer,Weatherboard,Asbestos Cement. The selection that I have made from...

how do i highlight the max blank cells in column "F" between 2 numbers i assume i can do this with conditional formatting

I am looking for a formula that would sum the first 3 or the first 6 numbers of the decimal part of a number. Assume decimal number is in cell A1. Thanks.

Dear Sir, I am righting a formula using if condition and v-lookup command where I am facing a problem. I have four column assume P=0.05 Q=0.1 R=0.15 S=0.2. Formula as stated below. =IF($X$125=20,IF($Y$125=500,IF($Z$125>=0.05<=0.1,VLOOKUP(REFRENCE CELL NUMNER,RANGE,TRUE),"ERROR"))) The...

I have a cell which is dependent upon 2 other cells. For simplicity's sake let's say: Z9 = (A1*B2) I would like to generate a report table of various values that Z9 could be. <table x:str="" style="border-collapse: collapse; width: 192pt;" width="256" border="0" cellpadding="0"...