Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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. Re: Splitting out title, first name, middle name, last name

    Nicely done, Peter! (of course)
  3. Replies
    16
    Views
    295

    Re: Sum numbers between two specific cells

    What would happen if, for example, there were two 6s?
  4. Replies
    16
    Views
    295

    Re: Sum numbers between two specific cells

    What did you add to get 10?
  5. 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. 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. 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. 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. 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. 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. 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. 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. Re: Most common number that proceeds a specified value in a list

    I also suspect the OP means precedes.
  14. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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 2 3 4