# Call in the Cavalry - 2018

1. ## Re: Call in the Cavalry - 2018

I'm absolutely not getting anywhere here. Some help please!

2. ## 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. ## 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

4. ## 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

5. ## 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. ## 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.

7. ## 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

8. ## Re: Call in the Cavalry - 2018

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

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

9. ## Re: Call in the Cavalry - 2018

Originally Posted by Glenn Kennedy
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. ## 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

11. ## 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. ## 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

13. ## 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?

14. ## Re: Call in the Cavalry - 2018

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

15. ## 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?

Page 6 of 11 First ... 4 5 6 7 8 ... Last

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

#### 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