Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    7
    Views
    184

    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,...
  2. Replies
    7
    Views
    184

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

    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
  4. Replies
    7
    Views
    184

    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.
  5. 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,...
  6. Thread: If formula

    by kweaver
    Replies
    1
    Views
    60

    Re: If formula

    What is the IF statement referencing?

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

    Something like that?
  7. Replies
    5
    Views
    138

    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...
  8. 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...
  9. Replies
    5
    Views
    138

    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: ...
  10. 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)
  11. Replies
    2
    Views
    131

    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...
  12. Replies
    2
    Views
    47

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

    by kweaver
    Replies
    7
    Views
    190

    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...
  14. Replies
    6
    Views
    153

    Re: Concantenate problem

    Glad it worked.
  15. Replies
    6
    Views
    153

    Re: Concantenate problem

    Please post an example.
  16. Replies
    6
    Views
    153

    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...
  17. Replies
    1
    Views
    73

    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"...
  18. Replies
    11
    Views
    225

    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...
  19. Replies
    11
    Views
    225

    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...
  20. Replies
    11
    Views
    225

    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...
  21. Replies
    11
    Views
    225

    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"...
  22. Replies
    11
    Views
    225

    Re: VBA: cancel file selection

    Fname As String
  23. Replies
    11
    Views
    225

    Re: VBA: cancel file selection

    Part of the code:


    Dim statements
    Application.ScreenUpdating = False
    Set DestWbk = ThisWorkbook
    Fname = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls*), *.xls*",...
  24. Replies
    11
    Views
    225

    VBA: cancel file selection

    I have a macro that prompts a user to select a file that is subsequently saved as a sheet and the data used in calculations.
    If the user cancels at the prompt to select a file, how do I avoid an...
  25. Thread: PDF to Excel

    by kweaver
    Replies
    6
    Views
    239

    Re: PDF to Excel

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

    I am using Acrobat Pro XI.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4