Call in the Cavalry 2024

Happy New Year, everyone!

Anybody fancy a run at this!

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

I know how to build the chart in this thread, but the OP also wants help designing the overall spreadsheet. Where and how to best input the raw data, how to have the tables at the top, and have the chart as desired. It isn't the kind of spreadsheet programming I do, so I'm not very good at it. My current thought is that, if one built a good "database" for the raw data, the "reporting" tables and the chart table could be extracted from the raw data with filters/pivots, but, as noted, those aren't my strengths.

https://www.excelforum.com/excel-cha...bar-chart.html

Can someone help with some coding here please?
https://www.excelforum.com/excel-gen...ml#post5912471

Is this even possible with a CF formula? Or will it require VBA?

https://www.excelforum.com/excel-for...mic-range.html

The request in post #7 of this thread may be possible using either 365 function based formulas or VBA. I don't know enough about either to help.
https://www.excelforum.com/excel-for...ml#post5915436

PQ based request:

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

This member isn't getting any traction. Can anyone assist?

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

I'm confident this formula can simplified using a LET() or LAMBDA() or similar function, but lack support in my older version. Can anyone step in with a solution: https://www.excelforum.com/excel-for...ml#post5925327

Can anyone else have a look at the chart in the attached file? The OP has a picture showing the chart truncating the line in the chart at 9 Feb, but, when I open the file, the line extends to 22 Feb. I can't debug the problem if I can't see the problem, and I cannot seem to guess what would cause Excel to fail to draw the line connecting the last few data points in the chart. I'm wondering if it is a problem specific to the OP's version or installation of Excel, and hope that one of you can recreate the problem and debug it.

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

Anyone got any thoughts, ideas, suggestions, comments on this thread:

Fragile Excel

This one is more a maths/stats problem: https://www.excelforum.com/excel-for...el-format.html

Can anyone assist with this?

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

Can someone look at this... https://www.excelforum.com/excel-for...ml#post5932741
they cannot get my answer to work but it works for me in my sample I attached. It could be a translation issue though I tried translating into Norwegian.
It doesn't error out.
they want an active hyper link that they click on to take them to today's date in col C. Is it a Google sheets issue?

This one is more of a maths/stats question than an Excel question. Any takers?

https://www.excelforum.com/excel-gen...r-of-88-a.html

This ine needs a 2021 solution (no 365 available): https://www.excelforum.com/excel-for...-products.html

Second half of this needs solving (Excel 2019 or VBA): https://www.excelforum.com/excel-for...f-entries.html

This is a maths question: https://www.excelforum.com/excel-for...-a-sprial.html

I got very close with this one, but fell at the final hurdle - any takers?

https://www.excelforum.com/excel-for...and-below.html

Re. post #20, it's still unfinished - one final shot here: https://www.excelforum.com/excel-for...and-below.html

Thanks!

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

In this one, the user is importing text files (eventually to be tens or hundreds of thousands of records) into Excel and then summarizing the data by the minute. Something about this process is taking a long time. I recall bumping up against a similar issue in the forum years ago (for an earlier version of Excel) where grouping a pivot table by minutes or seconds took a very long time for the pivot table to refresh. I don't recall details and can't find the earlier thread.

Perhaps one of you who is much more familiar with pivot tables (and the whole process of importing text files and summarizing with pivots) could chime in on why this user is having trouble and propose more efficient solutions.

Regarding this thread: https://www.excelforum.com/excel-gen...-included.html

I crafted a 365 solution (as per the OP's forum profile) only to be told that the solution needed to work with Excel 2019 (forum profile now changed). Any takers?

EDIT: Forget this. The OP has now decided that they have 2021, but in fact it's an old version of 365. Utter confusion!

This seems to have turned into a VBA requirement: https://www.excelforum.com/excel-pro...ng-a-date.html

Any takers?

Originally Posted by AliGW

This seems to have turned into a VBA requirement: https://www.excelforum.com/excel-pro...ng-a-date.html

Any takers?

Looks like it's been solved since you put out the call for help. Props to you for staying with what must be have been a tedious effort.

Thanks, Jeff, but I didn't find it tedious.

Formulae are not going to work fully for the OP here: https://www.excelforum.com/excel-pro...-a-date-2.html

It requires VBA to populate the Gantt cart from a form-generated table and CF applying.

I am probably making this one more complicated than it needs to be, but could someone else take a look? I have reached my limit with it.

https://www.excelforum.com/excel-for...ts-vs-act.html

Anyone want to have a go at this: How to arrange attendance table?

The OP wants to rearrange some data. Profile says 2019 but would also like a (separate?) solution for 2021. Or would take a VBA solution.

Originally Posted by zbor

I'll create VBA

Thank you.

OP is looking for a non Power Query Solution

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

I am not making any progress in trying to help in this thread. My understanding is that the OP is looking for a google sheets formula which they believe is going to work differently from the Excel formula provided in post #11.
https://www.excelforum.com/for-other...ml#post5965263

Can someone have a look at this?

https://www.excelforum.com/excel-gen...eze-panes.html

I can't work out what the issue is, although the OP is convinced that their formulae are at fault.

Can someone have a look at this?

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

I haven't been able to get the OP's code to work, nor the solution in the link I provided.

I can't make sense of the data or the requirement here: https://www.excelforum.com/for-other...ple-sheet.html

I am probably missing something obvious.

Also struggling to get my head around this one: https://www.excelforum.com/excel-for...nce-table.html

All fun and games here but we could use some help from someone with proper knowledge in statistics.

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

Needs someone with a US locale: https://www.excelforum.com/excel-for...requested.html

This one started out being about blanks that were not blank, but has morphed into something more fundamental about pivot table theory and practice that is above my pay grade. Anyone good with pivot tables want to join the discussion?

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