# Search:

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

Page 1 of 6 1

1. ## Thread: VBA: need unique values from a column

by kweaver
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:

2. ## Thread: VBA: need unique values from a column

by kweaver
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...
3. ## Thread: VBA: need unique values from a column

by kweaver
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
4. ## Thread: VBA: need unique values from a column

by kweaver
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.
5. ## Thread: Removing first character and last 3 in range

by kweaver
Replies
5
Views
196

### 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,...

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?

by kweaver
Replies
5
Views
139

### 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. ## Thread: Extract text between a character and first space left of that character.

by kweaver
Replies
5
Views
152

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

by kweaver
Replies
5
Views
139

### 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. ## Thread: Help creating a formula to count blank cells in row since last infraction

by kweaver
Replies
1
Views
49

### 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. ## Thread: need the column number of a value

by kweaver
Replies
2
Views
134

### 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. ## Thread: Search highest value code in list

by kweaver
Replies
3
Views
62

### 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:...

by kweaver
Replies
7
Views
195

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

by kweaver
Replies
6
Views
156

by kweaver
Replies
6
Views
156

by kweaver
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...
17. ## Thread: Fill from price list

by kweaver
Replies
1
Views
79

### 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. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### 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. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### 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. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### 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. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### 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. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### Re: VBA: cancel file selection

Fname As String
23. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### 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. ## Thread: VBA: cancel file selection

by kweaver
Replies
11
Views
230

### 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
242

### 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