As mentioned by FlameRetired
As mentioned by FlameRetired
Thank you again Glenn.
Anyone still using Excel 2007???
Anyone fancy having a look at this manage filter cell from another sheet
I thought a sample file might clarify the requirement but, for me, it didn't.
It's been up over a week with lots of views and now the OP is getting himself in trouble by PMing people asking them to look at the thread.
Thanks and Happy New Year to everyone if it's not too late to say that.
Trevor Shuttleworth - Excel Aid
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
Happy New year 2023! And, Gong Xi Fa Cai to those celebrating the Chinese New Year!
Could anyone take a look at this thread https://www.excelforum.com/excel-for...ted-items.html please? I have no idea how to proceed.
Using VBA, I could probably easily take care of the deleting of dups, but the combining results from column L, I'm not sure.
Can someone please help to look at this thread: https://www.excelforum.com/excel-for...ml#post5781784.
Anyone care to take a look at this. The OP wants what it says on the tin, to combine 3 VBA functions.
Combining 3 VBA functions into a single VBA sub
I don't have time to unravel it and wondered if anyone else was up to the challenge.
I feel like Power Query would be the easiest choice for extracting the data from the two tables and combining into one for the stacked bar chart the OP is requesting here: https://www.excelforum.com/excel-pro...ml#post5790746 I don't know PQ, so cannot help. As near as I can tell, the goal is to put together a table where we have start time and and end time/durations for select "line names" so that we can then build the stacked bar/Gantt chart that visualizes the operation.
Originally Posted by shg
Another database management thread that goes way beyond my skill set: https://www.excelforum.com/excel-pro...ml#post5791957
The OP is getting a daily text file (with data every half hour of the day). I have recommended the possibility of using these text files to build a solid database that they could then use to perform all kinds of daily, weekly, monthly analyses. Can any of you database + Power Query experts step in and help with the things the OP can/should do to build a good database from these daily text files and later add new days to the database?
Could someone using the 365 edition take a look at this thread pertaining to a new feature (to me) of Autocompletion from a drop-down list?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Anyone willing to take a look at this thread?
Seems simple enough but I might have overlooked something as my results are not the same as the OPs
Three of us have looked at this and not been able to "solve" it.
I have been having trouble deciphering the OP's notes and since I believe they are still looking for a solution I thought I'd post it here...
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
FAO Glenn Kennedy maybe?
How can I convert this google sheet formula to excel?
The OP is using a FILTER function in Google Sheets but wants to convert to Excel 2016. I have seen clever stuff done with FILTERXML but it is not a strong point for me.
Thoughts and ideas would be appreciated from anyone/everyone.
I see no solution here outside of VBA. I guess the OP is wanting all the hundreds of charts because of some type of report.
I do not understand what the OP is getting at. Can anyone discern and solve?
why are all these posts blank???...
OK weird, now they are no longer blank
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
I have a strange 1 here...
MATCH() should work, but it doesnt. Read my comments in post #4 there
I went through the same thing @ 2 weeks ago. I hit F5 and it cleared up, but I had to do it with each thread. It eventually cleared up (after I posted about it).
I'm way out of my league here. Any ideas?
The OP would like to format data points in a pivot chart based on value i.e., <3% green and >=3% red. My feeling is that it might be possible if a regular chart is produced from the pivot table, however I am ignorant of how that works.
Could someone with Word VBA experience have a look at this please
Adding Non-breaking space to both ends of a text selection
This looks like it will become a database design project. https://www.excelforum.com/excel-gen...c-diagram.html I'm not skilled at database design, but I figure there are several of you who know how to put together databases in Excel that could help with moving data from an input tab into a database and then build some simple count/summary data off of that database.
The OP here wants a spill formula to populate dates in a column, but I just don't get what the formula he currently has is supposed to be doing. Anyone fancy taking a look?
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
Wants to compare words in a single cell string against another such cell. (Excel 2007)
OP has added several conditions adhoc. Grrr. This may be beyond my skill set. Maybe VBA is a better route. I cannot tell right now but will continue to explore.
Meanwhile any "takers"?
Print area issue - no idea what else to suggest given the dearth of detail. Anyone?
I can't see the wood for the trees here: https://www.excelforum.com/excel-for...variables.html
Looks like it should be easy, but I cannot understand exactly how he wants it to work. I understand the arithmetic, just not the layout.
VBA date copy/paste problem
CS post says that when he runs the VBA code, it copies dates from one place to another incorrectly. On examination of his sample file, some dates are pasted as date values and some are pasted as text. The ones pasted as text are correct but the ones pasted as values reverse the day and month.
I used his file and ran his code and it worked perfectly.
I suspect the issue is somehow related to the regional settings. If someone uses European date formats and would like to try this the thread is worth 20 points and is not locked.
| | |會 |會 |會 |會 | |:| | |會 |會
Read the rules
Use code tags to [code]enclose your code![/code]
It appears that the source data is in text format. Moreover, the source data is in US format, and trying to copy it is done on a computer with UK settings (or vice versa).
Excel is a very greedy tool when it comes to date conversions. It "likes" to convert to date anything that resembles it. I suspect that after copying, the "dates" in text format are the ones that Excel did not convert because the number of days (in US format in the second place) is greater than 12. For example, the "date" in US 07/15/2022 was not able to convert, while the "date" US 07/04/2022 is able to convert to UK format 04/07/2022.
If the source data were written in date format, the copying would probably run without any problems, because numbers are copied. In the case of date-like texts, some may convert to dates and some will remain texts. It seems that in the case of texts, we should first convert the data to dates using, for example, DATE, RIGHT, MID, LEFT formulas, and only then copy to the destination.
But this is just my guess, because I don't have access to the sample file.
Last edited by Artik; 05-01-2023 at 09:26 PM.
That was my conclusion looking at his screenshot but the actual file did not look like the screenshot. Someone in another forum provided a solution but I tried it and it's just plain wrong.
I told him I would just rewrite the code if he could explain what it's supposed to do.
The pivot table shown in the file attached to post #29 should be sorted ascending by the Days2 column.
As can be seen that isn't the case and I can not understand why.
The pivot table's source data is on the Tournament sheet.
Perhaps someone with more knowledge of pivot tables could resolve the issue.
Any help with this Google Sheets conditional formatting query? I cannot get my head around what the OP is trying to achieve exactly.
I spent all day on and off yesterday and another hour or so this morning solving the OP's first challenge, and now he has introduced another level of complexity. I don't have that amount of time for head-scratching today, so if anyone else wants to have a go, it's here: https://www.excelforum.com/excel-for...-criteria.html
If it's of help, I can probably explain the logic of the bit I solved more clearly than the OP did, so if you need that, just shout.
Ali, Thank you but NO thank you. I looked at yesterday's post and hadn't even the vaguest notion of what was wanted! Kudos for sticking at it.. I'm on the road today and will resist the temptation to have a go.
The logic was nowhere near as obtuse in the end as he made it - it took longer to get my head around that than the solution, but the final sticking point was curious, and I learnt something about using VSTACK along the way that I hadn't anticipated!
I bet you won't be able to resist it ...
And I know there's at least one other here who will probably be working on a much simpler 2D spill array, so let's watch this space!!!
I am happy to help people get over a sticking point when they're stuck but when the time needed is measured in hours it sounds more like a consulting project for free. I tend to avoid those.
So do I, but my puzzle-mad brain got the better of me and I was determined to work out what was going on. It is not as complicated as it looks, but it took ages for the penny to drop for me.
I asked OP for a workbook with sample data. OP posted workbook with sampledata that looks alright I guess.
Only problem is, I can't see the pattern...
<----- 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)