Happy New Year, everyone!
Happy New Year, everyone!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Anybody fancy a run at this!
https://www.excelforum.com/excel-for...-register.html
HTH
Regards, Jeff
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
Originally Posted by shg
Can someone help with some coding here please?
https://www.excelforum.com/excel-gen...ml#post5912471
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
PQ based request:
https://www.excelforum.com/excel-gen...ml#post5921680
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
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
Some strange ribbon and instance creation behaviour. Perhaps someone has a suggestion.
https://www.excelforum.com/excel-pro...ml#post5943937
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!
Last edited by AliGW; 05-24-2024 at 03:03 AM.
This seems to have turned into a VBA requirement: https://www.excelforum.com/excel-pro...ng-a-date.html
Any takers?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
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.
OP is looking for a non Power Query Solution
https://www.excelforum.com/excel-pro...ml#post5964978
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
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
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
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
This one I think needs a Lambda/Let function for which I am not up to speed.
https://www.excelforum.com/excel-for...and-shift.html
Anyone want to take a look at this VBA pivot table creation? OP is getting an error that I cannot replicate.
https://www.excelforum.com/excel-pro...matically.html
Since you dealing with dates than it's date format problem.
CurrentDate = Format(Date, "YYYYMMDD")
When I open file and run the macro I see:
Now you need to check how do you see those dates and how user see it...Please Login or Register to view this content.
And where you rely on date formats in your code...
I can repeat again that 99% problems I get in VBA is related to date formats.. Sad that developers never try to work on that problem...
Never use Merged Cells in Excel
Many of you are more skilled at handling text data than I am. In this one, the user receives a bunch of hand entered, inconsistent "keywords," and they need to run a lookup on these inconsistent keywords against a lookup table. Can anyone propose a way to run the lookup with these inconsistent text entries?
https://www.excelforum.com/excel-for...ml#post5989717
This one needs the attention of someone who's a loan officer at a bank or plays one on TV: https://www.excelforum.com/excel-for...-payments.html Even someone who knows the right questions to ask about the loan terms would probably help.
Can one of you experts please help to look at this thread please?
I am unable to think further, maybe my approach was wrong.
It's about employees' entry and exit dates with multiples entry and exit dates for the same employees.
https://www.excelforum.com/excel-gen...ml#post5993066
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks