d12

  1. tlc53

    VBA Code - Amend to include more references

    Hi there, Can anyone help me amend this VBA code to include more than one reference (if possible)? It currently refers only to D12 but I want to add another nine references - D68, D124, D180, D236, D292, D348, D404, D460 and D516. Thank you! Private Sub Worksheet_Change(ByVal Target As...
  2. E

    Alternative Formula

    Good evening, Would it be possible to have an alternative formula to the following as this only returns data if D12 is a alpha numeric value =IFERROR(LOOKUP(2,1/(Data!$AK$3:$AK$502=D12)/(Data!$AD$3:$AD$502=F12),(Data!$X$3:$X$502)),"") this matched D12 within AK3:AK502 and F12 within AD3:AD502...
  3. M

    #VALUE! error

    I am using the below formula for a sales calculator in my organization and am getting a #VALUE ! error. Once I fill in D12 the error goes away, but if D12 is blank, the error is there. I'm sure it's a IFERROR I need to put in the formula, but not sure where to enter and compete the formula to...
  4. A

    SUM based on an Array Criteria That is In A Different Cell

    I have a SUM IF formula that looks like this (there are additional sumifs criteria but removed them to keep example short) =SUMIFS('Data Pull'!$K$12:$K$24363,'Data Pull'!$C$12:$C$24363, $D12) Where D12 contains 51* Thus it only sums accounts that start with 51. I later wanted to to do the...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top