+ Reply to Thread
Page 6 of 6 FirstFirst ... 4 5 6
Results 76 to 84 of 84

Call in the Cavalry - 2018

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

    Re: Call in the Cavalry - 2018

    I'm absolutely not getting anywhere here. Some help please!
    HTH
    Regards, Jeff

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

    Re: Call in the Cavalry - 2018

    Don't have the patience to continue here:

    https://www.excelforum.com/excel-for...nt-groups.html

    Formula solution required.

  3. #78
    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,025

    Re: Call in the Cavalry - 2018

    Paul has "60" columns of data and asked for a formula that will provide the results... col A has dates, col B has numbers, col C has dates, col D has numbers, col E has dates... you get the picture. Combined a sumproduct for him that worked on what was provided then found out he has 60 columns (I assume 30 of dates and 30 of numbers) that are generated.
    Any thoughts on how to handle without tying together 30 sumproducts?
    https://www.excelforum.com/excel-for...us-column.html
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

  4. #79
    Forum Expert
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,284

    Re: Call in the Cavalry - 2018

    I have attempted to help one of our moderators, VLady, in determining some projections for enrollment. I would appreciate it if some of the mathematicians on the site would take a look and see if the method and results look alright.
    https://www.excelforum.com/excel-for...ml#post4931957
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Call in the Cavalry - 2018

    https://www.excelforum.com/excel-gen...-to-image.html

    If somebody has some time, to edit the answer to have the picture show up in an image viewer? Right now I have it to display on the sheet when the user selects a cell.

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

    Re: Call in the Cavalry - 2018

    I don't know that it is any secret that I am not that experienced with text manipulation. This one is getting beyond me: https://www.excelforum.com/excel-pro...ml#post4934759 In a nutshell, given a formula string, find the value(s), find the multiplier(s), and figure out how many of each value is represented in the formula string. I am hoping/expecting that some of you are more skilled with text manipulation and can solve this one easier than I can. Up to this point, I have focused on worksheet formula based solutions, but the OP is open to VBA. Some of you may know of VBA tools that may make this easier.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  7. #82
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    43,981

    Re: Call in the Cavalry - 2018

    I have a member that I am trying to help (in CS), and have given them what they wanted, but they then sent me a vid showing "show/hide" option that displays or hides a table (that has another table to the left of it). The inevitable question being - "how do I do that".
    Vid is here...
    https://s3.amazonaws.com/feg/The+Ana...r+02242018.mp4
    the hide/show is around the "Specifically: min. 9:14-9:20 (note the "Hide/Show Distribution" button in J2-K2 of video sheet),"

    My thoughts would be either a Pivot Table, Conditional Formatting or VBA - or a combo of those.
    Anyone got any thoughts??

    There are other parts they want added, but they should be relatively simple
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  8. #83
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013.. mostly
    Posts
    17,538

    Re: Call in the Cavalry - 2018

    Any mind readers, capable of looking at 185,000 rows....

    https://www.excelforum.com/excel-for...ml#post4936375
    Glenn



  9. #84
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    43,981

    Re: Call in the Cavalry - 2018

    Quote Originally Posted by Glenn Kennedy View Post
    Any mind readers, capable of looking at 185,000 rows....

    https://www.excelforum.com/excel-for...ml#post4936375
    I have asked - again - for a sample file

+ Reply to Thread
Page 6 of 6 FirstFirst ... 4 5 6

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