Call in the Cavalry - 2018

You wanted it - here it is!

Here's last year's: Call in the Cavalry - 2017

Thanks Ali

Thanks for the new thread Ali

No probs, chaps!

What's the help you want ??

What do you mean???

Or are you joking?

Just make a guess

OK - thanks for clarifying.

I don't know if this is quite yet at a "cavalry" point (because no one has answered, yet). https://www.excelforum.com/excel-for...r-columns.html
My reaction to the OP's mockup tables is that they look exactly like pivot tables, using QUARTILE() functions instead of the usual SUM/COUNT/AVERAGE/... functions that are readily available in the PT options. Obviously, a QUARTILE(IF(...)...) array function should be able to work. Before suggesting that, though, I was hoping someone could tell me if it is possible to do this using a pivot table instead.

Not sure I know how to continue this thread with a formula solution.

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

My thought would be to create a unique list from C11:C20, E11:E20 etc and then use the helper column, but not that good with the frequency formula which I suspect is needed.

But then again, maybe not. Any help would be appreciated.

The formula works fine until an external data feed appends in such a way that changes the formula range references. Anyone familiar with data connections or SQL issues?

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

Hi,

Your formula is going over the 255 character limit for FormulaArray. Fortunately, that is only down to the spaces added for readability, so you can reduce it to:

 ActiveSheet.Range("n8").FormulaArray = "=TEXT(COUNTIF(R7C:R[-1]C,""PSCXXXX-""&VLOOKUP(RC[-10],VLOOKUPNAMES,2,FALSE)&""-*"")+MAX(IF(LEFT(INDIRECT(""'""&R1C14&""'!N7:N50""),10)=""PSCXXXX-""&VLOOKUP(RC[-10],VLOOKUPNAMES,2,FALSE)&""-"",--RIGHT(INDIRECT(""'""&R1C14&""'!N7:N50""),4)))+1,""0000"")"

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

anyone want to have a crack at this one?
using VBA to change
XY scatter chart marker fill to gradient or
using bubble change gradientstyle and direction

just cant see to find the right combination
another quirk with excel in my books
any body know a work around?

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.

Would someone with VBA knowledge please see if the OP's request in post #9, which is when the data validation in cell E1 of the Tabelle3 sheet is switch between "alpha" and "beta" the original formulas should be written back into the cells in column A of the tabelle2 sheet, where they may have been overwritten by values (If the OP modifies a recipe). This might also be something that could be done using a template (another subject of which I have limited knowledge).
https://www.excelforum.com/excel-pro...ml#post4825591

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

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

Need some formula help here.

I thought I had a grasp on it until I remembered the Non-GE part.

I would put the data in a simple list, change the form to have field names and entry fields, and put a selector on the form to choose the data.

I think I was able to brute-force it with Boolean array formulas, lemme know if you see a screw-up.

Billy Spivey needs help with VBA and that is not one of my strengths. Here is the link, he is wanting a running clock when the sheet is open...
https://www.excelforum.com/excel-gen...ing-clock.html
Thanks.

This OP (https://www.excelforum.com/excel-gen...ock-price.html ) is using 2016's built in "forecast menu/utility" to do forecasting, but does not understand the different models being used. I pulled up the help file, which does not say very much about what is happening inside of this utility's "black box", and I don't have 2016 to explore with. Perhaps someone here who knows both the 2016 forecast tool and enough about forecasting can help explain what is happening inside of this "black box."

Solved OP's original question. Now they added another, unrelated question that I am unsure how to do.

https://www.excelforum.com/excel-for...t-working.html

Formulaic answer possibly involving an OFFSET type function.

Starts at post #12

I don't think this request is too hard but I am having trouble figuring out what the OP wants so maybe someone else can figure it out.
https://www.excelforum.com/excel-for...condition.html

This OP is trying to change the size of chart sheet chart objects: https://www.excelforum.com/excel-pro...art-sheet.html I proposed some code that works just fine for me in my installation of Excel, but the OP is encountering protection errors. I can't tell if they are specific to the workbook he is working on or if it is a more fundamental change in how VBA/Excel 2013 interact. If you know anything about this, please contribute. If nothing else, if you can test my code in your installation, that could help establish if this can work for him or not.

I had no idea what this guy wanted. Anyone facile with Whatsapp?

Anybody up for this?

I don't think we are having the same conversation and the formula makes little sense to me.

What am I missing?

I have an idea of how to fix this formula request, but just can't get it right. Also, the method would be to use an offset setup (I think), but with 350 and offset volatile, wouldn't that slow down the OPs sheet?

https://www.excelforum.com/excel-for...with-gaps.html

Deleted- I resolved it for him.

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

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

I suspect a 2016 glitch here. Anyone with 2016 care to try it?

Does anybody have an appetite for this?

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

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?

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.

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

Need some help from a formula guru here?

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?

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

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.

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

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

The OP appears to have created a histogram specialty chart from the new chart types available in 2016. I cannot view or test this chart type. Can anyone with 2016 verify that a logarithmic axis is not allowed in this specialty chart? https://www.excelforum.com/excel-cha...ml#post4900164

I have requested that the OP upload a sample file, but it is the kind of VBA programming that I don't really do. I probably won't be able to help very much beyond what I have already done: https://www.excelforum.com/excel-pro...ml#post4900972

OK, I have something here that's driving me nuts.

Using INDEX/SMALL/IF for a member...
=IFERROR(INDEX(Starters!A:A,SMALL(IF(Starters!$A$3:$A$246=$A$1,ROW(Starters!$A$3:$A$246)),ROWS($A$1:A1))),"")
Works fine, but if I extend the 2 ranges to more than $A$246, it stops working and returns nothing

what am I missing here?

Hi Ford,
There are #N/A errors in column A of starters below row 246, which causes the function to return an error. It's also a lot more efficient to replace Starters!A:A with Starters!$A$1:$A$246

Originally Posted by xlnitwit

Hi Ford,
There are #N/A errors in column A of starters below row 246, which causes the function to return an error. It's also a lot more efficient to replace Starters!A:A with Starters!$A$1:$A$246

Great catch, I should have checked that.

You can use column references in a formula like that, for the INDEX range, because it is outside the volatile array part of the formula (Tony - Biff taught me that)

Running an older version of Excel, I cannot really help with the new 3D maps feature in 2016. https://www.excelforum.com/excel-cha...ml#post4904100 Some of the details are still fuzzy, but someone else will have to help with the details of what can be done and how to do them.

OP would like a VBA based solution. I have supplied formulas that accomplish enough of the task that you'll hopefully be able to see what is required/requested. https://www.excelforum.com/excel-pro...ml#post4906799

OP would like a sum of all possible combinations of 9 meds for 99 patients.

this is interesting, I've not seen it before though I've never used this feature. The OP says that if you use the clipboard and copy each of the sets of values from A1 to A5, then B1 to B5 etc across the top, then go to cell A8 (clear the contents) and hit paste all it often leaves out some of the copied cells. I misunderstood his first post thinking he meant it was deleting (as if he cut instead of copied) the values. It was only after I tried pasting all the fourth time that it brought down all the contents.
So I have been able to replicate the issue though as I admitted I've never tried that feature before.
https://www.excelforum.com/excel-gen...ing-items.html
I did some internet research and didn't find a good answer.
I'll be interested in hearing what might be going on.
Thanks.

This might work fine for the OP, but curios if somebody else has another thought?

I don't really have an idea how to separate the letters in column B without using the helper cells.

Could a few of you take a look at thios
https://www.excelforum.com/excel-gen...ml#post4910251

OP seems to think they need a sheet for each driver/entry. Am I missing something or is there a better way to do this?

Thanks for the input and assist, guys (and gals), it can sometimes be hard to get people of the track they have climbed on lol

He rolled over quite easily in the end.

Yes, when he saw that I wasnt the only 1 with that opinion/suggestion, I figured that would happen as soon as others chimed in

I think we may have spoken too soon. He has had a rethink and is still wanting daily tabs. Might require a bit more cajoling tomorrow.

Can someone assist with some VBA code for this?
https://www.excelforum.com/excel-for...ml#post4911381
OP needs to copy a row of formulas to every 5th (or 6th) row, for 66k rows

OP has also posted here...
https://www.excelforum.com/excel-pro...as-please.html

I will close the 1st 1, so help can be offered on the other 1

Could someone offer some help here?

I provided a doubleclick method to add "checks", but now the OP would like to consolidate multiple lists into one. Not sure how to approach it. Sample is in the last post.

I have hit a mental block on this 1, at this stage.
https://www.excelforum.com/excel-cha...ml#post4915300

OP needs charts (only 3 - well, 2 plus 1), that he can change to show different exercises based on a DD

Originally Posted by FDibbins

I have hit a mental block on this 1, at this stage.
https://www.excelforum.com/excel-cha...ml#post4915300

OP needs charts (only 3 - well, 2 plus 1), that he can change to show different exercises based on a DD

JeteMc and benishiryo, thanks for the assist, great work, both of you

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.

any takes for #65?

Is anyone expert in scraping data from the web?

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

Can anyone offer any thoughts, ideas or suggestions for this thread: Activate Arrow Keys To Jump From Textbox1 to Right or Left

Could somebody offer some inputs here!

Here's another one I can't unscramble!

I hate to leave this guy hanging, but I have appointments this morning.

https://www.excelforum.com/excel-for...-1-column.html

He wants to append three columns of names into a fourth. I can do this in VBA but that isn't what he wants. See his second post for the file.

OP is doesn't allowed to use PowerQuery (IT problem?)
Excel 2010
Anyone with formula power?
https://www.excelforum.com/excel-for...-matching.html

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

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

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

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.

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

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

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

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

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

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

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

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?

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

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?

OP is missing Excel formula features in a recent purchase that includes Office 365. Since I have almost never used the Function Arguments dialogue I couldn't help.

Anyone?

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

It works on my test sheet, but not on the his supplied sheet (complete with merged cells and a colour scheme to drive you mental):

https://www.excelforum.com/excel-for...l-columns.html

Counting DISTINCT values in multiple non-contiguous ranges. I get integers as the result on my sheet, but on his (which has a horrendous link to external data) I get a non-integer result. Going boggle-eyed. Any ideas?

Anyone know anything about data tables (TABLE as an array)?

This one has me stumped: https://www.excelforum.com/excel-gen...t-working.html

woops replied to wrong thread...

Any Ideas on this Mac VBA problem?

https://www.excelforum.com/excel-pro...h-problem.html

I hate to post this one because I feel like I should be able to solve it (and I suspect I'll do a face-palm when I see what solves it).
but here https://www.excelforum.com/excel-gen...ket-share.html
So the OP wants the "adjusted share" values in col D to be adjusted in col E in order for col E to add to 100% BUT ONLY if you do not adjust the values that are in col D that are at 0.50%.
So essentially he wants E5:E8 to adjust so that all of E5:E14 sums to 100%.
What I proposed hit the 100% but it also adjusted the values in E9:E14 to less than 0.50% which he wants locked in.
So you might think it should proportionally distribute the first four values among the remaining 97% but that gets me close but I'm still off .05%.
And I expect that the formula has to account for a varying # of companies.
I'll be looking forward to what is proposed as my brain is fried dealing with work and different attempts at this solution.

I think Get and Transform is the way to handle this one: https://www.excelforum.com/excel-pro...-cvs-cell.html but the OP is skeptical. Anyone with more familiarity with Get and Transform either back me up (or shoot me down)?

Conditional formatting in Excel 2011 for Mac -- I guess it is not the same as the Windows versions. https://www.excelforum.com/excel-for...ml#post4973743 Can anyone more familiar with the Mac environment help?

Strange invisible "character" in a text import file. Fields in the same row following the offending field advance to the next row upon import into Excel. CODE/MID doesn't show anything, but arrowing through the field in Notepad indicates something is there.

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

63, I think we all know that feeling really well! Cudo's to you for "walking away" and asking for help, rather than just leaving the OP hanging - thank you for that