Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    79

    Re: Copy from one Merge Cell into a Column

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

    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...
  3. Replies
    6
    Views
    91

    Re: Pull info from First Column with Data

    Dante: that assumes all the values are always increasing.
  4. Replies
    6
    Views
    91

    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]
  5. Replies
    7
    Views
    188

    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,...
  6. Replies
    7
    Views
    188

    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...
  7. Replies
    7
    Views
    188

    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
  8. Replies
    7
    Views
    188

    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.
  9. 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,...
  10. Thread: If formula

    by kweaver
    Replies
    1
    Views
    62

    Re: If formula

    What is the IF statement referencing?

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

    Something like that?
  11. Replies
    5
    Views
    146

    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...
  12. 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...
  13. Replies
    5
    Views
    146

    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: ...
  14. 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)
  15. Replies
    2
    Views
    141

    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...
  16. Replies
    3
    Views
    64

    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:...
  17. Thread: Excel Formula

    by kweaver
    Replies
    7
    Views
    202

    Re: Excel Formula

    Does A1 have those other symbols (less than)? Are the numbers always starting with "91"? Are they all 10-digits? Are there at most 4? Could there be fewer or more numbers?
    Where do you want all...
  18. Replies
    6
    Views
    156

    Re: Concantenate problem

    Glad it worked.
  19. Replies
    6
    Views
    156

    Re: Concantenate problem

    Please post an example.
  20. Replies
    6
    Views
    156

    Re: Concantenate problem

    You may have inadvertently put a space after "steve"...click in the formula bar to see.

    Or you could try this: =TRIM(H1)&"."&TRIM(I1)&"@"&TRIM(J1)&".com" where I have the first name in H1, last...
  21. Replies
    1
    Views
    82

    Re: Fill from price list

    Welcome to the forum.
    Have you tried VLOOKUP?

    If you need help, please try to post a sample of your Sheet(s).


    <colgroup><col style="mso-width-source:userset;mso-width-alt:3657;width:75pt"...
  22. Replies
    11
    Views
    234

    Re: VBA: cancel file selection

    From research I see I can take my first of a few modules and write:

    Option Explicit
    Global flag Variable As String

    Then, use "flag" throughout each of my modules.

    I'll have to dig to see...
  23. Replies
    11
    Views
    234

    Re: VBA: cancel file selection

    Where do I declare a global variable? Is it before the initial macro? Then, what do I use to detect the CANCEL key has been clicked? Thanks for your helpful suggest. If I can learn how to do...
  24. Replies
    11
    Views
    234

    Re: VBA: cancel file selection

    I've seen a similar question asked elsewhere but there are never any applicable solutions. It seems (at least to me) that there should be a "simple" grand exit upon a condition.
    If MACRO_A calls 4...
  25. Replies
    11
    Views
    234

    Re: VBA: cancel file selection

    That code (which is a macro called "GetFile") where the user is given the prompt is called from another macro called "RunMacro".

    If the user selects a file, the next macro that's run in "RunMacro"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4