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