assume

  1. M

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Some videos you may like

This Week's Hot Topics

Top