Call in the Cavalry - 2022

Post here for 2022.

Thanks Ali

Happy New Ca!ll-in-the-Cavalry

Please could someone have a look at this thread for me. https://www.excelforum.com/excel-pro...ing-early.html

Note: I have added a blank header row to the data as the code starts at row 2.

To test, I am copying the Original Data to the Cleaned up Data sheet and repeating.

Basically, there are two simple loops. The last row is determined initially and equals 18. The first loop checks all the cells in the range A2:A18. The second loop SHOULD check all the cells tn the range C2:C18. However, it simply OMITS cell C3. The Debug shows cells C2, C4, C5, ... C18.

I have no idea why this is happening.

OP is using the 2010 version of Excel and would like to "lock columns that are automated" (see post #22).
File is in post #19.
https://www.excelforum.com/excel-new...ml#post5620696

Anyone feel like taking a stab at this 1?
https://www.excelforum.com/excel-pro...med-range.html

Does anyone have time to have a stab at this one?

https://www.excelforum.com/excel-gen...or-events.html

WARNING: Nightmare data!

Anyone for a PowerQuery one?

https://www.excelforum.com/excel-cha...-new-item.html

DAX formula question has gotten too complicated for me.

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

OK this 1 has me completely puzzled, any1 else feel like a head-scratch?
https://www.excelforum.com/excel-gen...ml#post5627316

Probably should have just left this one alone.

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

Anyone know anything about logical regression testing and standardising data?

I feel like this thread is turning into a lookup table/lookup function kind of thing that I am just not equipped to address: https://www.excelforum.com/excel-gen...ml#post5640244 I don't know whether to focus on getting a different "pivot/lookup" table to make the lookup function easier, or whether there is a better way to search the data for the 2 parameters the OP wants to search.

Anyone have a suggestion here

Can anyone help with this?

https://www.excelforum.com/excel-gen...with-time.html

It's a time difference issue where the hours between 1800 and 0600 need to be ignored. I am sure there is a much simpler solution, and there are now extra requirements, so it has got away from me.

Hoping that someone can improve on the power pivot measures I provided in post #4: https://www.excelforum.com/excel-cha...ml#post5647298

This is looking like a substantial project, and will probably venture into areas that I have no expertise in. I have asked the OP to focus on a specific part of the project to start, but if others can watch and contribute where they can: https://www.excelforum.com/excel-gen...j-program.html

Someone wanting to create/format a chart using VBA. I don't use VBA for charting, so I'm expecting that someone else will be better able to help with the VBA portion of this thread: https://www.excelforum.com/excel-cha...bar-graph.html

Someone here is having trouble calling Solver from VBA. I suspect a Reference error, but cannot verify (either a bad sample file or something in the OP's file that is not compatible with my older version of Excel). Can anyone with 2019 verify my results? https://www.excelforum.com/excel-pro...ss-solver.html

My older version of Excel does not support data labels from cells. Can someone with 2013 or later look at this and see if you can understand what is happening with the OP's data labels.
https://www.excelforum.com/excel-cha...ml#post5674493

I am having a mental block here, I think! Can anyone assist?

https://www.excelforum.com/excel-for...the-sheet.html

Does anyone fancy picking this one up?

https://www.excelforum.com/excel-gen...-the-week.html

Thanks.

The OP here (https://www.excelforum.com/excel-pro...rpolation.html ) wants to switch the current calculations (a double/bilinear interpolation) to a VBA UDF. Some of you will be better than me at this, so I'm requesting some back up on this one.

Anyone fancy taking on this SUMPRODUCT problem?

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

For those with the "newest" version of Excel, can you help explain the process of importing a text file here: https://www.excelforum.com/excel-gen...ml#post5681293 My old version (2007) has no trouble importing text files with different date formats using the old text import wizard, but I get the impression that the mechanics have changed dramatically in the newest version as Power Query gets more integrated into Excel.

Any one got any thoughts on how to "validate" a street address in Excel

https://www.excelforum.com/excel-for...ngle-cell.html

Anyone fancy trying to come up with a SPILL array formula for this one?

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

This has morphed into a VBA query. OP wants a cell to contain a look up but also be able to write back to the lookup list.

https://www.excelforum.com/excel-pro...other-cel.html

I can't figure out what this person is looking for, I tried a couple times to get them to clarify it a bit more but
perhaps someone can give it a look and see what new eyes can bring to the problem.

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

I'm striking out with an answer for this problem. Does anybody know how to select different rows of data for a chart using a named range?
https://www.excelforum.com/excel-cha...n-a-chart.html

I believe there are a couple quiery experts here that may be able to help.

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

This might be kind of a dumb question. I have a good idea how this moves forward, but I'm not sure if there would be a solid preference for putting the change event in the worksheet or have it be for the whole workbook: https://www.excelforum.com/excel-pro...n-formula.html

Sorry since I don't know how to follow this thread so I post something here.

Originally Posted by bebo021999

Sorry since I don't know how to follow this thread so I post something here.

I think you would go to thread tools and subscribe to thread

I am unable to post to this thread. It returns a blank screen. No other threads have behaved this way for me today.

https://www.excelforum.com/excel-for...ll-values.html

I have just posted to that thread.

Please can someone have a look at this thread:
https://www.excelforum.com/excel-pro...ml#post5705456

I am all out of ideas and going in circles.

I cannot understand the reasoning that is being used to come up with the expected values in this one: https://www.excelforum.com/excel-for...ml#post5705787

A very intesresting thread: ageing analysist.
To whom ready to deal with challenge.
https://www.excelforum.com/excel-pro...ml#post5706526

anybody could look into this thread:
https://www.excelforum.com/excel-pro...ml#post5710013
I can't get my head around with the application.Ontime each 15 mins. Need a cup of coffee now.

@bebo: see response in thread. Hope it helps.

Originally Posted by TMS

@bebo: see response in thread. Hope it helps.

Thank you. Could you give the OP the solution, not a link to study? I feel he is a quite new VBA user.

Could you give the OP the solution, not a link to study?

I intended the link to help you adapt your solution, not the OP.

Can someone who knows Power Query have a look at this please:

https://www.excelforum.com/excel-gen...red-in-it.html

I suspect it is a simple change, I just wouldn't know what.

Anyone up for the challenge of reverse engineering this with a view to streamlining it?

https://www.excelforum.com/excel-for...e-forumla.html

It makes my head want to explode ...

Not thinking clearly enough today - any takers? I don't think he needs PQ for this.

https://www.excelforum.com/excel-cha...wer-query.html

Don't know if formatting the data the way the OP wants is doable or not, however I have run out of ideas: https://www.excelforum.com/excel-gen...ml#post5719983
I hope that you have a blessed day.

Some unusual behavior by Excel in this one: https://www.excelforum.com/excel-gen...ml#post5727749 If I understand correctly, Excel is randomly clearing date formatting from cells when the OP performs some kind of refresh operation. I've requested more information from the OP, but I'm also hoping someone here may have ideas of when/why Excel would clear number formatting from cells (when not explicitly told to clear number formatting).

Can someone with Excel 2016 look at this and confirm the OP's complaint that his formulae are not working?

https://www.excelforum.com/excel-for...ce-2016-a.html

Has a call-in-the-cavalry-2023 been started yet? If so I cannot find a link. If not how/who starts one?

I just did...

Thank you Glenn.

Unstuck... as has 2021's...