# assume

1. ### Put number and autocomplete to nearest date?

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...
2. ### count unique dates by weekday

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...
3. ### Copying down a value in a cell until the Value Changes

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...
4. ### Assistance Combining Two Codes

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...
5. ### Data Filter between two date with in single column

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...
6. ### Ctrl-F does not find formula result....

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
7. ### Hard Numbers in a formula

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...
8. ### Asterick "*" Causing incorrect summation in an array formula - any advice?

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...
9. ### Lookup table/Index

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...
10. ### Lookup table /Index

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...
11. ### max highlighting between 2 numbers

how do i highlight the max blank cells in column "F" between 2 numbers i assume i can do this with conditional formatting
12. ### summing first 3 values or 6 values of a decimal number

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.
13. ### Interpolation of values

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...
14. ### Report, from assumed set of variables.

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

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

### Which adblocker are you using?

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

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