+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3
Results 31 to 42 of 42

Call in the Cavalry - 2018

  1. #31
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    10,919

    Re: Call in the Cavalry - 2018

    If anybody has time to figure this out, I'm sure OP would appreciate it.

    https://www.excelforum.com/excel-pro...e-matched.html

  2. #32
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,931

    Re: Call in the Cavalry - 2018

    Does anybody have an appetite for this?
    HTH
    Regards, Jeff

  3. #33
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3,089

    Re: Call in the Cavalry - 2018

    If someone feels like building a formula for unstructured data.

    Thread is located here.

    I think that the OP does not understand the value of correctly formatted data.

  4. #34
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    2,370

    Re: Call in the Cavalry - 2018

    This is most likely an easy fix for a Mac person, the bulk of the problem is already solved very nicely it seems. I advised TS to take it to the Mac section but that resulted in a bit of a pinball effect between threads. Feeling a bit guilty for that now.
    So, Mac path issue, 5 min fix anyone? https://www.excelforum.com/excel-pro...-involved.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  5. #35
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,931

    Re: Call in the Cavalry - 2018

    No doubt this is rather easy, but can't quite get the syntax right to pass to a specific sheet. Can somebody help out please?

  6. #36
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,417

    Re: Call in the Cavalry - 2018

    I just don't have time to work on this:

    https://www.excelforum.com/excel-pro...text-file.html

    I give rep for a good answer. I think the problem is defined well enough now.
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  7. #37
    Forum Expert
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4,928

    Re: Call in the Cavalry - 2018

    I have gone as far as I can with this one. The OP has an array per cell in column A and needs to extract the minimum value from each cell. I have gotten two formats in columns E:F (file attached to post #7) and feel that at least one of those could be used by a UDF to eliminate the need for the helper columns H:CL.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  8. #38
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,931

    Re: Call in the Cavalry - 2018

    I think I may have exhausted whatever VBA prowess I may posses, so can somebody with a stronger VBA knowledge help out here?

  9. #39
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,931

    Re: Call in the Cavalry - 2018

    Need some help from a formula guru here?

  10. #40
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    7,551

    Re: Call in the Cavalry - 2018

    Not sure this can be done. OP has 20 golf players. Wants no duplicated pairings over a 15 week period.

    Anyone want to take a "swing" at this one?
    Dave

  11. #41
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    7,551

    Re: Call in the Cavalry - 2018

    I'm stumped. The title says it. I keep hitting dead ends, and no system of helper columns/rows seem to help. I'm on my 5th draft.

    Extract Sequential Numbers of 5 or More Into Separate Columns

  12. #42
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Excel 2013 - work; 2012 for Mac at home
    Posts
    3,675

    Re: Call in the Cavalry - 2018

    I think the OP (whose initials are OP - ha ha) needs a VBA solution to their issue if I'm understanding their question. My initial response met their needs as stated but then they elaborated.
    https://www.excelforum.com/excel-for...ked-cells.html

    EDIT: maybe I'm over thinking it but this was their first request...
    I have a workbook where cells P1:P4 are the same on 5 worksheets. Is there a way to enter the data on any one of the sheets and it populates the same cells on the other worksheets?
    then this was their second post...
    Is it possible to execute an on a change event to perform this function whenever P1:P4 are active in any of the workbooks? The problem I have is that this change could talk place at multiple steps in the process and I want to be able to update all the sheets at any time.

    which sounded to me like VBA.

    OP marked it as solved with a VBA solution.
    Last edited by Sambo kid; 04-19-2018 at 01:30 PM.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1