Search:

Type: Posts; User: kweaver; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Excel Formula Assistance (If Statement w/lookup and SUM)

    Your #3 , if I'm reading it correctly: put this formula in the cell of Sheet3 where you want the answer.

    =IF(Sheet1!A10="ABC",Vlookup("ABC",Sheet2!W1:X100,2,false),"")

    You didn't say what you...
  2. Replies
    3
    Views
    41

    Re: Sorting Issue - not working as expected

    That did the trick. Thanks!!!
  3. Replies
    3
    Views
    41

    Sorting Issue - not working as expected

    I have a simple sheet that looks like this:

    http://www.kevinrweaver.com/Sort1.jpg

    more data

    http://www.kevinrweaver.com/Sort2.jpg

    And, I'm using the following code within other code in...
  4. Re: VBA cannot find SUMIFS in WorksheetFunction class

    Thanks. That's what I concluded in my post #2 and already incorporated it into the code. Thanks for confirming!!
  5. Re: VBA cannot find SUMIFS in WorksheetFunction class

    I haven't tried that, but don't think it will work because the 2nd element of the SUMIFS function needs to be a range which is used to match the third element.
  6. Re: VBA cannot find SUMIFS in WorksheetFunction class

    I suppose I have to separate the range for Arg1 into two separate ranges??
  7. VBA cannot find SUMIFS in WorksheetFunction class

    What's wrong here?


    Dim Arg1 As Range 'the range i want to sum
    Dim Arg2 As Range 'criteria range
    Dim Arg3 As Range 'the criteria (range)

    Set Arg1 =...
  8. Replies
    11
    Views
    165

    Re: SUM INDEX MATCH Help.

    DanteAmor has written the sumproduct.

    His example sums the J column when the concatenation of the two A-column values match the Transfers in the F column and the A3 value matches the E column in...
  9. Replies
    11
    Views
    165

    Re: SUM INDEX MATCH Help.

    Without trying to reproduce your roughly million rows, I would suggest you consider SUMPRODUCT as an option.
    Have you tried that?

    Or post a smaller version of your file with examples.
  10. Replies
    3
    Views
    142

    Re: Copy from one Merge Cell into a Column

    Actually, F2 can be this: =IF(ISNUMBER(FIND(",",A2)),A2,F1)
  11. Replies
    3
    Views
    142

    Re: Copy from one Merge Cell into a Column

    I came up with a quick solution using a helper cell (which you could hide).

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  12. Replies
    6
    Views
    154

    Re: Pull info from First Column with Data

    Dante: that assumes all the values are always increasing.
  13. Replies
    6
    Views
    154

    Re: Pull info from First Column with Data

    One way is to use this ARRAY formula: =INDEX(C2:K2,MATCH(FALSE,ISBLANK(C2:K2),0)) [enter with CTLR+Shift+Enter]
  14. Replies
    7
    Views
    223

    Re: VBA: need unique values from a column

    Thanks to both of you. I put a header in G1 and H1 (same header in each) and if I F8 my way through it using this:


    Sheets("Summary").Range("G1:G" & LRsum).AdvancedFilter Action:=xlFilterCopy,...
  15. Replies
    7
    Views
    223

    Re: VBA: need unique values from a column

    For some reason (I don't know why), I had a repeat of the smallest value in the sorted list of the G column that got placed in the H column.

    Maybe my explanation wasn't correctly worded. I want...
  16. Replies
    7
    Views
    223

    Re: VBA: need unique values from a column

    Would this be the best way?


    Range("G2:G" & LRsum).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("H2"), Unique:=True
  17. Replies
    7
    Views
    223

    VBA: need unique values from a column

    In a worksheet (called Summary) I have values from G2 to Gn and I'd like column H from H2 to however long to be the unique values from G.
  18. Re: Removing first character and last 3 in range

    You could use a formula: =0+LEFT(RIGHT(AJ1,LEN(AJ1)-1),LEN(RIGHT(AJ1,LEN(AJ1)-4))) and fill down
    Or VBA per this formula:


    Sub remove()
    Dim LR As Long, i As Integer
    LR = Cells(Rows.Count,...
  19. Thread: If formula

    by kweaver
    Replies
    1
    Views
    72

    Re: If formula

    What is the IF statement referencing?

    =IF(A1<100000,"0XX",IF(and(A1>=100000,A1<999000),"1XX","2XX"))

    Something like that?
  20. Replies
    5
    Views
    163

    Re: Sumproduct Question

    A few examples would help (at least help me) because I - N are only 6 columns, where you said there could be 1-10 lifters (are they the rows) and 1-60 lifts (where are those listed?).
    Did you pull...
  21. Re: Extract text between a character and first space left of that character.

    One way: =MID(A1,1+FIND("%",A1),FIND(" ",A1,FIND("%",A1))-FIND("%",A1)-1)

    With your string in A1 (and fill down, if more strings). This pulls the text after the % until the first space after the...
  22. Replies
    5
    Views
    163

    Re: Sumproduct Question

    Welcome to the forum. At least for me, I cannot understand how a 5 should be returned without knowing what's in the cells you're checking.
    Also, you've misplaced the parens: ...
  23. Re: Help creating a formula to count blank cells in row since last infraction

    I think I found 2 ways:

    =6-LOOKUP(2,1/(B2:F2<>""),COLUMN(B2:F2))

    and

    =5-AGGREGATE(14,6,(COLUMN(B2:F2)-COLUMN(B2)+1)/(B2:F2<>""),1)
  24. Replies
    2
    Views
    158

    Re: need the column number of a value

    If the input results in A1, then A2 would give you the month match and the column number: =MATCH(A1,B1:M1,0)+1

    Another way could be: =MONTH(1&LEFT(A1,3))+1

    Or simply: =MONTH(1&A1)+1

    Is...
  25. Replies
    3
    Views
    86

    Re: Search highest value code in list

    All formulas, but with helper columns:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4