Call in the Cavalry - 2021

Here it is!!!

Let's hope that 2021 is a better year for all of us.

No problem.

Forcing Sum of percents to equal original total

https://www.excelforum.com/excel-for...ent-split.html

Confused:
I think the OP wants a very simple thing. I am just not understanding what it is. LOL, is it me or are we missing information?

https://www.excelforum.com/excel-for...-products.html

Suggestions for scheduled macro to run.

https://www.excelforum.com/excel-pro...in-column.html

Here is a PQ and Hyperlinks situation. I can't get it to work. Its in CS, so there is a couple $$ available to the finder.

https://www.excelforum.com/commercia...ml#post5475284

I can't tell how much of this is just me and how much is gibberish.

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

Mark it to get future notice.

Mark what, Bebo?

Originally Posted by AliGW

Mark what, Bebo?

Then "User CP" to tell me if there is new port in this thread

You can use Subscribe to This Thread under Thread Tools - no need to actually post to a thread to get notifications.

https://www.excelforum.com/excel-cha...ml#post5484718

This discussion has gone from basic "how do I create a scatter chart in Excel" into something more about immunology/molecular biology/biochemistry, none of which are my field of expertise. I seem to recall that one or two of you here may have experience in these fields, and, hopefully, may be better able to provide information about how the experiment should go and how the data from the experiments would be analyzed.

I think I could handle the spreadsheet programming side of this question, but I just cannot quite understand what the raw data from the experiment should look like, so I cannot really advise on how to go from running the experiment to know what data the experiment should generate. If any of those fields seem familiar to you, have a look and see if you can help better than I can.

The boolean logic here got too complex for my brain today.

https://www.excelforum.com/excel-for...culations.html

Need help from VBA expert!
OP want to read cell colour .
https://www.excelforum.com/excel-for...ext-color.html

I'm not that familiar with pivot tables. This user has combined a couple of different sources into a pivot table and is having trouble getting something from the resulting pivot chart: https://www.excelforum.com/excel-cha...ml#post5492114
Perhaps someone can jump in and help.

I don't think this is possible without VBA but feel free to prove me wrong. Looking for a conditional conditional formatting.

https://www.excelforum.com/excel-for...formattng.html

Anybody? Maybe it should be moved to the VBA forum?
https://www.excelforum.com/excel-for...formattng.html

This user is bringing data into Excel with Power Query, and then needs a simple subtraction/duration calculation performed. I was wondering if it would be easier to perform the subtraction/duration calculation as part of the Power Query import process rather than do it with spreadsheet formulas after the import: https://www.excelforum.com/excel-gen...ml#post5497027

I can't get my head around what the OP is asking for here: https://www.excelforum.com/excel-gen...g-pincode.html

OP's spreadsheet is crashing after implementing an Arrayed Formula (Excel 2007). There's not a lot of data so I don't think it should crash. Can someone with IT knowledge take a look at this?

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

Really need VBA helpers. It can be solved quickly with formula, but the OP hope to get VBA solution for large database.

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

Need VBA here, now, it seems (the OP has just mentioned that he wants a VBA solution!!!

I still have NO CLUE what the process is that he wants to automate - can anyone work out what washing and sweeping are???

https://www.excelforum.com/excel-pro...from-file.html

A FILTER() function that sometimes returns a Spill error that I cannot debug: https://www.excelforum.com/excel-gen...ml#post5502595

This OP has presented an issue that is above my ability to solve. VBA is the means as it involves .interior.colorindex over four different ranges that need to be compiled.

https://www.excelforum.com/excel-pro...ls-pt-2-a.html

This link is my own question: How to merge cells without losing data? In file attached, cells inside merged range seem not to be deleted!

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

Bebo - this is NOT what this thread is for. You posted your query only three minutes before posting here. This thread is for when someone has worked to try to help an OP over a protracted period of time, but hit a roadblock and is calling for someone else to have a look.

Please don't misuse this thread again.

Could someone whom is familiar with dynamic array formulas please take a look at the question about whether or not the formulas in post #6 will automatically fill down (I think that is called spill).
https://www.excelforum.com/excel-for...ml#post5514814

Could someone chip in here: https://www.excelforum.com/excel-for...ment-date.html

I'm swamped at work at the moment - no time to follow it up. Thanks.

https://www.excelforum.com/excel-for...n-dataset.html
Post #8
I solved the initial question but my solution to the follow up (post 8) would be very long. I think one of you formula geniuses can come up with something shorter.

Anyone able to finish this one, please?

https://www.excelforum.com/excel-gen...xclusions.html

I resorted to redimensioning a range with this one.

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

I can't help but believe someone adept at using FILTERXML could pull off a better solution. This function is a complete mystery to me. Every time I try to understand it I swear I go "snow blind". LOL

Need a VBA person, not my forte.

https://www.excelforum.com/excel-gen...ormatting.html

Looking to color specific cells either at opening or at push of a button. Thanks in advance.

I can't explain this behavior.

https://www.excelforum.com/excel-gen...ted-cells.html

Anyone on here familiar with Lotus 123 files, functions and formulae?

In this thread, there is a requirement to convert a couple of files from Lotus 123 to Excel. i can get them into Excel, via LibreOffice, but there are formulae and functions that are not familar to me. They produce #NAME? errors.

Can anyone shed any light, convert them

https://www.excelforum.com/excel-for...ml#post5549919
OP would like to know if, when a new row is inserted into an Excel table, VBA could copy formulas into the new row and then sort the table based on those formulas.

Is anyone able to cut to the chase in this thread? Maybe I am being exceptionally dense this morning, but I cannot work out exactly what the OP is asking for.

https://www.excelforum.com/excel-for...audit-due.html

This OP wants to Custom format for days hours, minutes and seconds. Trouble is sometimes the desired days output is larger than the 31 day limit.

I have not been able to come up with anything that does not create a concatenated string ...

Any ideas?

The OP here https://www.excelforum.com/excel-cha...ml#post5555282 is requesting detailed instructions for formatting a data series. Since I am not familiar with the O365 UI, I am wondering if it would be helpful for someone more familiar with the O365 UI could help with the details of finding the options for formatting a data series in a chart.

The OP here https://www.excelforum.com/excel-gen...ml#post5555444 says he wants to use checkboxes or similar to determine what points should be shown in a chart. Since I don't use those kinds of "controls", I cannot help much.

OP could use some VBA help here please...
https://www.excelforum.com/excel-new...ml#post5556749

OP states their original post disappeared and they are having difficulty uploading. I can see his post fine and his file downloads at my end.

He may just need assurance from others (and maybe a trained eye to critique his request since I don't do VBA).

Dave - he says he would prefer formulae, NOT VBA!

Thanks Ali. I must have missed that.

OP needs a tweak to his VBA code.

https://www.excelforum.com/excel-pro...-workbook.html

This Power Query issue has me stumped. Need someone with really good Mcode experience to work on this. I cannot get it.

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

This thread probably needs VBA expertise of which I have none.
The OP would like to put 60k names into selectable sized groups based on one, two or three criteria (i.e. City and/or Subject and/or Priority).
https://www.excelforum.com/excel-pro...ml#post5580234

This OP is getting duplicate counts where he says they aren't. I suspect it has to do with "**" embedded in the literal strings that COUNTIFS is treating as wildcards. I seem to recall there is a way to deal with these but do not recall what it is beyond requiring leading "~".

Any ideas? https://www.excelforum.com/excel-for...ml#post5581229

Any members want to take a crap at this 1? I had, in error, initially closed this a password cracking, but I have now opened the thread - please help the OP.

https://www.excelforum.com/excel-pro...using-vba.html

Here is another 1...
https://www.excelforum.com/excel-pro...h-formula.html

Is there a new Sticky for 'Call in the Cavalry' page for 2022?

If you know of one please post the link.

There is now: https://www.excelforum.com/the-water...ry-2022-a.html

Bless your heard Ali and thank you. I now have that link bookmarked.

You're most welcome.

By the way .... that was heart.

I forgot to run my post through speel cheeker.

The grammar checker would have caught it, but not the spell checker!!! LOL!!!