+ Reply to Thread
Page 6 of 7 FirstFirst ... 4 5 6 7 LastLast
Results 76 to 90 of 92

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

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

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

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

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

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

    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
    44,515

    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 & 2016
    Posts
    18,107

    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
    44,515

    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

  10. #85
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2013
    Posts
    188

    Re: Call in the Cavalry - 2018

    I have little to no experience with documents coming from/going to share point. Would someone be able to tell if that's what's causing the issues here:

    https://www.excelforum.com/excel-gen...ml#post4940992
    If it'd make you feel better using my answer because of my street cred, then you can go ahead and click Add Reputation below to improve it.

  11. #86
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,425

    Re: Call in the Cavalry - 2018

    After reading the OP's last post it now seems to me that her/his need is to copy the data from several spreadsheets (chennai1, thoothukudi, coimbatore, mudara) into one spreadsheet (Print) and then filter the table in the Print sheet based on two criteria. I feel that copying data from several sheets and placing it in one sheet is best accomplished using VBA, of which I am basically illiterate. I am therefore asking if someone that writes VBA would look at/pick up this thread.
    https://www.excelforum.com/excel-for...ml#post4947002

  12. #87
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,314

    Re: Call in the Cavalry - 2018

    OP's initial post was 7/25/2018. They've been waiting a while. Has uploaded a workbook. OP wants to do calculations on a table, pivot table and multiple slicers ... I think.

    I have no idea what they are trying to do and I cannot come up with a coherent question.

    https://www.excelforum.com/excel-gen...ml#post4950461
    Dave

  13. #88
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,266

    Re: Call in the Cavalry - 2018

    I have no clue where to begin with this one: https://www.excelforum.com/excel-for...-or-count.html

    It's some sort of what-if scenario with rankings. Anyone want to give it a go?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

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

    Re: Call in the Cavalry - 2018

    I had a look too, also wasnt sure what they wanted

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

    Re: Call in the Cavalry - 2018

    Power Query/Get and Transform are far removed from my needs and experience, but this problem seems like it could easily be tackled with these tools: https://www.excelforum.com/excel-pro...ml#post4952869 Can any of you with more experience with Power Query/Get and Transform comment?

+ Reply to Thread
Page 6 of 7 FirstFirst ... 4 5 6 7 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