Search:

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

Search: Search took 0.01 seconds.

  1. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Perfect...thank you so very much.
  2. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Oooops…here's an example - Before looks good until we get to 5th Place. After eliminated 6th place, however, we lost "Tied - 1st Place - 2nd Place" and "Tied 3rd Place - 4th Place"....is there a...
  3. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Eric...this works, absolutely brilliant - is there an enhancement that would eliminate "Tied - 5th Place - 5th Place" and just return "Tied - 5th Place"?
    I can't tell you how much I appreciate...
  4. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Eric and Fluff - here's what I just tested: Player 1 and 2 are ranked 1 (formula displays "Tied - 1st Place - 2nd Place", Player 3 and 4 are ranked 3 (formula displays "Tied 3rd Place - 4th Place",...
  5. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Eric...this looks like it will work - wow, nice work.
  6. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Fluff...the two or more players tied for 1st would be shown in the notes section (each player - adjacent to their name): Tied - 1st and 2nd Place.
    If there were a total of 10 players and each...
  7. Re: Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    Thanks...formula worked really nice - I would like the ties to reflect the possible positions, e.g., if the 1st 2 players are tied for 1st, then the text should read "Tied - 1st and 2nd Place".
  8. Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

    I have ranked a list of players by score (low to high using the Rank function) and wish to designate (using text) the present standing (1 to 5 places) of the player. If 2 players are ranked 1, the...
  9. Replies
    8
    Views
    253

    Re: Multi Column vLookup

    Alex89...thanks, I like this function (never used it before), unfortunately, I was unable to adopt it to solve my issue. I need to find a single value that could appear in any of the 1st 4 columns...
  10. Replies
    8
    Views
    253

    Re: Multi Column vLookup

    Thanks so much...I just incorporated the formula into my workbook and it works GREAT!
  11. Replies
    8
    Views
    253

    Re: Multi Column vLookup

    Steve...perfect solution without using an array...thanks so much
  12. Replies
    8
    Views
    253

    Re: Multi Column vLookup

    Eric...this is great, thanks...is there a way to create the above solution without using an array formula?
  13. Replies
    8
    Views
    253

    Multi Column vLookup

    I have a 5 column table - Column 1 thru Column 4 contain unique names; Column 5 contains a time value. I am attempting to use vLookup to search for a unique name that may appear in Column 1 thru...
  14. Replies
    7
    Views
    341

    Re: Golf Handicps Values

    Great job...thanks - I'll give it a go.
  15. Replies
    7
    Views
    341

    Re: Golf Handicps Values

    Thanks sooooo much - exactly what I was looking for.
  16. Replies
    7
    Views
    341

    Golf Handicaps Values

    I have a list of player names that are divided into 5 Flights (A to E). Each Flight is determined by dividing the list of names with associated scores into 20% or less of the total players. Each...
  17. Replies
    11
    Views
    482

    Re: Golf Handicps

    Kevin...your solution is terrific, however, I have run into a "brick wall"...here's the problem: We use 5 flights and divide the 5 Flights into Foursomes. Is there a reasonable solution for this...
  18. Replies
    11
    Views
    482

    Re: Golf Handicps

    Kevin - Thanks again
  19. Replies
    11
    Views
    482

    Re: Golf Handicps

    Kevin...not sure if my reply made it through. Your solution looks really great - I will need to spend some time reviewing it - thank you so much. I'll let you know how i make out.
  20. Replies
    11
    Views
    482

    Re: Golf Handicps

    Your assumption is correct - brilliant...I will try your formula - thanks so much; I'll let you know
  21. Replies
    11
    Views
    482

    Golf Handicaps

    I have a list of 100 names with associated golf scores/handicaps. I need to develop 5 Flights (A, B, C, D, E) into which players will be placed based on their score/handicap, e.g., players who score...
  22. Replies
    6
    Views
    183

    Re: Select Cell From Formula

    This works perfect...thank you so much
  23. Replies
    6
    Views
    183

    Re: Select Cell From Formula

    Thanks...I'll try this shortly
  24. Replies
    6
    Views
    183

    Re: Select Cell From Formula

    I used this formula to determine the exact location of the cell I wish to select -
    <colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
    ...
  25. Replies
    6
    Views
    183

    Select Cell From Formula

    Using the cell "address" function, I have identified the cell location (address) of the cell I need to select. I need to write VBA code that uses this returned address to select the corresponding...
Results 1 to 25 of 25