# Search:

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

Page 1 of 6 1

1. ## Thread: Vlookup based on conditional match

by kweaver
Replies
2
Views
31

### Re: Vlookup based on conditional match

Welcome to the lounge.

I didn't use a VLOOKUP for this. If the titles are in C1:Cn (I used a name range) and the number of pages are in E1:En (again, used a name range), then this should work...
2. ## Thread: Splitting out title, first name, middle name, last name

by kweaver
Replies
15
Views
231

### Re: Splitting out title, first name, middle name, last name

Nicely done, Peter! (of course)
3. ## Thread: Sum numbers between two specific cells

by kweaver
Replies
16
Views
295

### Re: Sum numbers between two specific cells

What would happen if, for example, there were two 6s?
4. ## Thread: Sum numbers between two specific cells

by kweaver
Replies
16
Views
295

### Re: Sum numbers between two specific cells

What did you add to get 10?
5. ## Thread: Vlookup to return the nth value.

by kweaver
Replies
3
Views
80

### Re: Vlookup to return the nth value.

Sorry, this: where the 2 is the second occurrence to be found in the InvList and return that value from the InvList. Change the 2 accordingly.

should have been where the 2 is the second...
6. ## Thread: Vlookup to return the nth value.

by kweaver
Replies
3
Views
80

### Re: Vlookup to return the nth value.

I believe you can do this with 1 ARRAY formula (CTRL+Shift+Enter):

=INDEX(Received_Process,SMALL(IF(InvList=FindValue,ROW(InvList)-ROW(INDEX(InvList,1,1))+1),2))

where the 2 is the second...
7. ## Thread: Splitting out title, first name, middle name, last name

by kweaver
Replies
15
Views
231

### Re: Splitting out title, first name, middle name, last name

That's a problem! GRIN

I clearly made some assumptions based on the OP's post and my own thinking.

This type of problem is very tricky. There could be an ESQ, III, Sr., Jr., type of suffix at...
8. ## Thread: Splitting out title, first name, middle name, last name

by kweaver
Replies
15
Views
231

### Re: Splitting out title, first name, middle name, last name

If all the names have a prefix and there are no suffix abbreviations on any name AND if everything is separated by a space (phew), I think this (UGLY) formula set works:

<b></b><table...
9. ## Thread: Error opening file after sorting, saving, and closing

by kweaver
Replies
3
Views
41

### Re: Error opening file after sorting, saving, and closing

You nailed it, of course. So nice to hear from experts here -- and so quickly as well! Thanks!!!
10. ## Thread: Error opening file after sorting, saving, and closing

by kweaver
Replies
3
Views
41

### Error opening file after sorting, saving, and closing

I have an Excel workbook with a tab named "Master". I have a sorting button that calls this routine:

Sub SortByEmpNo()
Sheets("Master").Activate
With ActiveSheet.Sort
.SortFields.Add...
11. ## Thread: Parse email address from long strong

by kweaver
Replies
6
Views
90

### Re: Parse email address from long strong

Here's one approach that seems to work with your long string in A1, the parse starts in A2.

Sub SplitEmail()
Dim strg As String, newstrg() As String, result As String, i As Integer, locb As...
12. ## Thread: Parse email address from long strong

by kweaver
Replies
6
Views
90

### Re: Parse email address from long strong

Your example doesn't show < or >, so what does the data really look like?
13. ## Thread: Most common number that proceeds a specified value in a list

by kweaver
Replies
7
Views
84

### Re: Most common number that proceeds a specified value in a list

I also suspect the OP means precedes.
14. ## Thread: VLOOKUP not finding data that is present

by kweaver
Replies
9
Views
162

### Re: VLOOKUP not finding data that is present

On the "List..." sheet, I put this in the K6:K1804 column: =trim(clean(D6)) and filled down.

Then, in C4 on that sheet, I entered: 108-05-4 and in D4 I put: ...
15. ## Thread: VLOOKUP not finding data that is present

by kweaver
Replies
9
Views
162

### Re: VLOOKUP not finding data that is present

From which sheet are you running this vlookup? Where's C4? None of the sheets have anything in C4.
16. ## Thread: Traffic light warning system

by kweaver
Replies
14
Views
292

### Re: Traffic light warning system

Look at my post. Mentor didn't mean =B2/C2 but should have been as my post indicated ( =B2/A2 ). That's probably why you're getting the error.
17. ## Thread: VLOOKUP not finding data that is present

by kweaver
Replies
9
Views
162

### Re: VLOOKUP not finding data that is present

Welcome.

You shouldn't need the &"" ... Does your D column on the other sheet have add'l spaces or non-printable characters?

I would probably help if you could post your data somewhere.
18. ## Thread: Traffic light warning system

by kweaver
Replies
14
Views
292

### Re: Traffic light warning system

If you mean "what % of the income is equal to the expense?" --

Column C would be formatted as a percent after: =B2/A2 which in the case of \$1000 and \$100 would result in 10%
19. ## Thread: Traffic light warning system

by kweaver
Replies
14
Views
292

### Re: Traffic light warning system

As Mentor suggests...
Have you tried 3 conditional format formulas?

Select your range (e.g., A1:A100) and apply these three:

=AND(A1>=0%,A1<=10%) [font or fill as green]...
20. ## Thread: Count number of times a specific text appears in a string & range

by kweaver
Replies
9
Views
110

### Re: Count number of times a specific text appears in a string & range

Are you saying that if there's a * in the cell, not to consider this in the count?
21. ## Thread: Count number of times a specific text appears in a string & range

by kweaver
Replies
9
Views
110

### Re: Count number of times a specific text appears in a string & range

Have you tried this in C1 with the word you're searching for in B1:

=COUNTIF(A1:A100,"*"&B1&"*")
22. ## Thread: IF statement

by kweaver
Replies
13
Views
252

### Re: Need help with IF statement

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
23. ## Thread: IF statement

by kweaver
Replies
13
Views
252

### Re: Need help with IF statement

From what you said, aren't you just doing: E204-F203 and filling that down?

Where does the result (78 in this case) go?
24. ## Thread: Index/Match formula

by kweaver
Replies
4
Views
86

### Re: Index/Match formula

Try this:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
25. ## Thread: Consolidating rows

by kweaver
Replies
4
Views
96

### Re: Consolidating rows

What about something along these lines?

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