+ Reply to Thread
Page 3 of 8 FirstFirst 1 2 3 4 5 ... LastLast
Results 31 to 45 of 106

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
    11,184

    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
    8,083

    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,998

    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,379

    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
    8,083

    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,767

    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 Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,589

    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
    8,083

    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
    8,083

    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 - Office 365
    Posts
    8,626

    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 - Office 365
    Posts
    8,626

    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
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,247

    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

  13. #43
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    9,726

    Re: Call in the Cavalry - 2018

    I am just not familiar with more advanced pivot table features, and this OP seems to want something other than one of the built in summary functions. Anybody add to my meager suggestions here?

    https://www.excelforum.com/excel-cha...ml#post4890052
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  14. #44
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,184

    Re: Call in the Cavalry - 2018

    I probably ended up getting mixed up doing this, maybe somebody else has a faster approach.

    https://www.excelforum.com/excel-pro...ml#post4891773

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

    Re: Call in the Cavalry - 2018

    This OP seems to somewhat have the answer, but somebody else with a little more charting experience want to look into this?

+ Reply to Thread
Page 3 of 8 FirstFirst 1 2 3 4 5 ... LastLast

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