@ abousetta
Uploaded a new file...please look at the Thread again...been playing with it a bit too long and had a bit of brain freeze. EndRow was declared as long in the Globals Module...for some reason I commented it out. Does the new File function for you as expected?
http://www.excelforum.com/excel-prog...ded-range.html
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
OK here's a wierd 1...
http://www.excelforum.com/excel-gene...int-print.html
When I open that thread, all I get is (attached) Tried to reload and refresh a cpl of times - same thing
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
@FDibbins
It's in printable view...had that happen to me several times...don't know why...
FD,
I fixed it for you. All you need to do is go to the excel general subforum and click to the side of the title and edit it. There is a sticky in the mods forum about it too.
Only mods and admins can fix such titles.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@ FDibbins,
Many times I seen that kind of posts in which we can't do anything
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
John,
If the OP creates a thread with "print" as the last word, it goes into print preview mode, which does not allow anyone to reply to it.
If you find such threads, please bring them to our notice.
Thanks for the update and assist - 1st time I have seen that 1
Hi Jake,
No errors are popping up on my system.
Hope this helps.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hi,
anybody mind taking a look at http://www.excelforum.com/excel-prog...ll-sheets.html for a check/helping hand? I don´t have a version of 2010 available for the time present (and won´t for the next week and a half starting today).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Maybe vba for this one???
371 columns don't know how many rows to be copied in new workbook I think.
http://www.excelforum.com/excel-form...copy-text.html
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There is just too much going on from this thread. Perhaps someone with an ounce more patience can go through all that code to figure out the problem and fix it.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
@tigeravatar, you are my hero for understanding that person's requirements. Thanks.
http://www.excelforum.com/excel-gene...d-as-text.html
Can anybody else help this guy. I thought this was going to be about converting numbers to text or text to numbers, but it has turned into a completely different "trying to average a subset of this database based on a few different criteria" kind of problem that is out of my league.
Originally Posted by shg
Can any-one help with this?
http://www.excelforum.com/excel-form...n-or-cell.html
OP has 2 lists, wants to find data from 1st list in 2nd list, but although the names match, some are pretty jumpled
Hi,
Here is a problem with lots of workbooks in a very organized folder structure. Grabbing and pulling in lots of different files isn't my strength. Anybody up for this code? I've just been busy all day....
http://www.excelforum.com/excel-prog...-a-folder.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Why this doesn't work for rows, only for columns?
http://www.excelforum.com/excel-gene...ate-value.html
Edit: Done.. i forgot to put delimiter in my own UDF :D
Last edited by zbor; 06-29-2013 at 03:55 AM.
Anyone have some help for this OP?
http://www.excelforum.com/excel-prog...html?p=3293659
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
A new and unique question, I've been unable to find anything Googling. Any suggestions here for changing the default drop down currency options on the Home tab?
there was suggestion of adding a cell style to the qat and doing that way on mrexcel
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I think that is the suggestion I referenced from Microsoft Community. But that doesn't answer if it's possible to edit this actual drop down defaults. So far it's looking like no.
I also Googled around for quite a while on this one and couldn't find anything. Guess they might have to settle for a Custom Number Format in specific cells, even more so if they wish to see a "Q" as the symbol, and not the default (I'm guessing here) GTQ for Guatemalan Quetzal.
Anybody want to take a crack at this?
HTH
Regards, Jeff
The interesting thing about this thread was perhaps not so much the problem itself, but the extent to which the OP (and dare I say some others who looked at the problem?) believed that this was a matter of counting the number of 'coloured' cells.
Of course, we were talking about coloured cells as the result of Conditional Formatting here, and I'd be pushed to think of a case where you'd actually need to go to the effort of developing some sort of colour-counting script rather than analysing the rules behind the CF to resolve the problem.
In this case, the solution turned out to be surprisingly simple, yet it seemed to take a while and some coaxing to drag the OP back to the logic behind the original CF and away from his (fixed) idea that this was a question of 'counting the coloured cells'. It's almost like the original logic behind these cell colourings had been lost/forgotten and they had to be treated as independent, random entities to be dealt with.
Anyway, think I better get some more coffee before I start getting too philosophical!
You got the OP to the correct solution in the end XOR LX - job done, reputation added......
Audere est facere
Anybody want to have a go here?
I have got as far as I can on this 1. OP needs some VBA now, any-one want to jump in?...
http://www.excelforum.com/excel-form...25#post3304525
Can someone pitch in here? Not getting time to work on it - http://www.excelforum.com/excel-prog...one-sheet.html
Thanks much.
I could probably brute-force my way through this 1...
http://www.excelforum.com/excel-form...deadlines.html
But Im sure there is an easier way, just cant think of it off-hand
Hi all, I've been trying to help out this person but he/she is just not getting what I want for an upload. Can someone take over? Perhaps this just requires new eyes. See here.
Some simple VBA coding perhaps
http://www.excelforum.com/excel-gene...-of-times.html
Life's a spreadsheet, Excel!
Say thanks, Click *
Maybe some-one else can solve this question.
http://www.excelforum.com/excel-prog...=1#post3308716
Thanks in Advance.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I'm at work right now so I don't have a good sample file here, but, in the meantime, does anybody have a routine put together that would satisfy this OPs request?
http://www.excelforum.com/excel-gene...ain-sheet.html
Am I missing something in this post:
http://www.excelforum.com/excel-form...iven-dept.html
My array formula works for 2007 users, but not 2003... even though all of the functions are available in both versions as far as I can tell... I don't know why it's not working correctly. Anyone want to have a look?
Thanks,
Moo
anyone do access?
http://www.excelforum.com/access-tab...-birthday.html
can any-one help with this?
http://www.excelforum.com/excel-form...if-loop-3.html
G'day,
Not sure if I'm allowed to be in this thread but I've been trying to help this guy out & it has gone beyond my capabilities. No-one else has jumped in with any suggestions so I thought I would come to the best.
http://www.excelforum.com/excel-form...der-table.html
Thanks in advance
No problem, moppyau, it's open to everybody.....
Thanks Mate. Hope someone can help.
Last edited by moppyau; 07-09-2013 at 08:46 AM. Reason: Typo
I ran into a problem on this one (VBA)...
http://www.excelforum.com/excel-prog...html?p=3314148
Basically the problem is that they want to disable saving so I put in a "are you sure you want to exit" type beforeclose event, rather than the usual message. It gets retriggered when I try to close the workbook though and if I turn off events then they stay off when the workbook is closed. It seems like it should be something that has been looked at before but couldn't find anything on google and the only methods I could think of were:
1. open up a new workbook, generate a macro to close the other workbook and call that macro, which would then turn events back on.
2. put an if statement into the macro to check whether something has been changed to define whether the macro is being "rerun", ie a cell on an obsolete sheet.
I don't particularly like using either method though and was hoping there was a more elegant solution.
OP in this thread is looking for a formula to number rows of data from 1 to 21 but skipped 13 and a blank row in between. I can write a mini-monster for this simple task, anyone got something really clever and elegant?
I'm way short in the formula department so haven't a sound clue for this...
http://www.excelforum.com/excel-form...-breakers.html
Any takers?
Something I've never considered before. I know how to search for files on my own local computers using wildcard filters. But the OP in this thread needs to pull a file down from a web site where part of the filename is know and part is not, so a wildcard would be needed. But the Data from Web tool seem to turn the "*" into part of the file name when it goes to the web, thus it fails.
So, how does one pull a non-exact filename from the web?
Maybe someone here will have the time for this person, they don't want to try and want someone to make a form for him/her. I won't/can't right now and he/she won't even try.
http://www.excelforum.com/excel-form...ent-cells.html
i cant see how you can match the colours in say range b1:b20 and repeat them in a1:A20 when using sliding colour scales conditional format excel 2007
prob need some code
That link is broken Martin.
Last edited by jeffreybrown; 07-11-2013 at 08:40 PM.
Anyone with a working knowledge of Pivot tables and vba want to help the OP out here. I cleaned up his code but it's giving the wrong results and I'm not at all an expert on pivot tables.
Thanks.
abousetta
VBA
In the topic below, the OP ask for a column to row solution.
Normaly I use a code for that.
The problem in this case is that in the header row are differant sections, which have to put in differant columns too (not only all values in one column).
Who can and is willing to help me (and the OP) with this item.
http://www.excelforum.com/excel-form...51#post3320551
This one might just be a translation issue (english to non-english function). As I'm not familiar with Excel in other languages, is there anyone who cares to comment on how to use the LINEST() function in other languages (if indeed that is the problem)? http://www.excelforum.com/excel-char...into-cell.html
this one is out of my wheel house: http://www.excelforum.com/access-tab...able-isam.html
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
Can anyone take a look here?
http://www.excelforum.com/excel-prog...next-line.html
The code's fine (well the OP hasn't complained about it), but the formula isn't - Me + formulas = disaster.
Is what the OP wants to do even possible with formulas?
If posting code please use code tags, see here.
http://www.excelforum.com/excel-char...int-chart.html
i have absolutely no idea on this except Pointing op to
http://peltiertech.com/WordPress/exc...nt-background/
any one have any other ideas?
Anybody up for some vba with IE and js... http://www.excelforum.com/excel-prog...-vb-macro.html
abousetta
Think I might be getting out of my depth here - never been able to get my head round VBA clases.
http://www.excelforum.com/excel-prog...-argument.html
Anyone have any clues on what this guy is asking?
code needed here >>>>>>>
http://www.excelforum.com/excel-prog...p-by-step.html
Can any=one help with this?
http://www.excelforum.com/excel-prog...matically.html
http://www.excelforum.com/excel-form...n-vlookup.html
need a bit of multi concat here in vba
link changed but i think jb has solved it
Last edited by martindwilson; 07-23-2013 at 12:04 PM.
Martin, was that thread deleted or something? When I try to follow the link, I get "No thread specified."
[EDIT]:
Ah, ok. new link works just fine, and yeah, JB has done some great work on it
Last edited by tigeravatar; 07-23-2013 at 12:32 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
colour schemeses vba any one
http://www.excelforum.com/excel-prog...matically.html
Seems to be cryptic to my mind in finding the way to get the result in formula/vba code...
http://www.excelforum.com/excel-prog...t-numbers.html
This user needs a formula solution which is not my cup of tea
http://www.excelforum.com/excel-prog...-than-1-a.html
I offered UDF + formula solution but the OP is looking for Macro solution.
I am not an expert in using Scripting Dictionary or Array in vba and I am sure it will be an easy task for those who are well versed in it.
http://www.excelforum.com/excel-prog...html?p=3337413
oh why do i do it misread post asked for workbook then realise its VBA anyone like to look?
http://www.excelforum.com/excel-prog...-criteria.html
vba help needed and in german! now thats really out of my depth
http://www.excelforum.com/non-englis...-32-000-a.html
http://www.excelforum.com/excel-prog...-32-000-a.html
I'm at a loss here.
http://www.excelforum.com/excel-prog...ification.html
Some assistance here please.
Not sure where to start as I don't think the worksheet change event will capture a change an external source.
This 1 has me stumped, I cant figure out how they do the breakdown...
http://www.excelforum.com/excel-form...html?p=3341180
pivot table difference between years well i thought it simple just put the calculation outside the table but that's not want op wants,i tried calculated fields and all
sorts
http://www.excelforum.com/excel-char...-the-data.html
oh a good day batch rename folders from excel vba
http://www.excelforum.com/excel-prog...name-them.html
I have to step out for quite a few hours, can anybody help here.
Hello,
I opened this thread just to ask you what I did wrong, what it should not be in those codes because the op(s) says somehow it's not working but for me it work very well.
I tried to help because I received help...
I appreciate your thoughts.
http://www.excelforum.com/excel-prog...cel-sheet.html
http://www.excelforum.com/excel-prog...e-xyz-pdf.html
MODERATOR'S NOTE: Merged into this thread which already exists for this purpose.
Last edited by JBeaucaire; 07-30-2013 at 12:22 PM.
blue
Any suggestions here regarding getting a better WYSIWYG: http://www.excelforum.com/excel-gene...t-preview.html
Some help here please on how not to use a helper column...?
http://www.excelforum.com/excel-gene...-an-array.html
Last edited by JBeaucaire; 07-31-2013 at 02:00 PM.
Hi Jeff
That link appears to be broken...
I've corrected Jeff's link.
http://www.excelforum.com/excel-gene...44#post3349544
Either the OP had trouble following the instructions in the 2010 help file, or MS has made it more difficult than it is in 2002 to hide tick mark labels. Anyone with one of the newer versions help us understand how this is supposed to happen in 2010?
OP wants help with comboboxes
I have no experience with that. who can and is willing to help.
Thanks in advance.
http://www.excelforum.com/excel-prog...06#post3351006
Does anybody have a way to do this without the helper cell?
Hi,
Can someone come to my assistance here, please? I may not have offered the best solution as I didn't do my research () and it appears that the EVALUATE function may have an upper limit of 255 characters on strings passed to it.
If anyone can clarify this in the post and/or offer an alternative solution (imagine full VBA needed now), I'd be grateful.
http://www.excelforum.com/excel-form...n-a-range.html
Thanks a lot
Can this be done without VBA?
http://www.excelforum.com/excel-gene...a-in-cell.html
You have given one of these...
http://www.mrexcel.com/forum/excel-q...alidation.html
Different approach??
Hi again,
This is an interesting phenomenon and one which may require a more technical explanation than the one I gave if anyone has the time.
http://www.excelforum.com/excel-form...ng-result.html
Regards
This is not anything I can even come close too...
Any takers?
Here is a tough call to get the result using worksheet function
http://www.excelforum.com/excel-gene...html?p=3364418
I haven't a clue how to answer this one. Your help would be appreciated.
http://www.excelforum.com/access-tab...75#post3364575
Anyone please take care of this thread since I am little bit confused about the OP's requiremnt
http://www.excelforum.com/excel-form...-criteria.html
Good day sixth
can you look at this one. maybe we could come up with a better approach.
help.xlsx
Thanks for the response vlady and good day to you too...
I have gone through your file and tried to create formula with the help of your helper formula's, but really I am stumped
=IF((ROW(E5)-ROW($E$5))<10,IF(SUMPRODUCT(COUNTIF(E5,LARGE(((ROW($E$5:$E$24)-ROW($E$5)+1)<11)*$E$5:$E$24,{1,2,3,4}))),"X",""),IF(SUMPRODUCT(COUNTIF(E5,LARGE(((ROW($E$5:$E$24)-ROW($E$5)+1)>10)*((ROW($E$5:$E$24)-ROW($E$5)+1)<16)*$E$5:$E$24,{1,2}))),"X",""))
The above is the formula I developed but I am little bit tired and running out of time to go further and I know it is not the right approach too... lol
yup the conditions of the OP are really odd.
I'll post the file there and lets see what he really wants.
Hi all,
Can anyone offer the OP on this thread advice on protecting workbooks other than the standard options (if such things exist)? He evidently isn't happy with the level of security offered. Don't know much about such things, and never really had need to. Any help appreciated.
http://www.excelforum.com/excel-gene...dataset-2.html
Thanks a lot.
Here's another one that seems to me like it should be really easy (plot data in a scatter plot with no marker and the thinnest line possible). Perhaps it is merely our (the op's and mine both) unfamiliarity with the newer interface, but something doesn't seem right in what he describes.
http://www.excelforum.com/excel-char...h-problem.html
Anybody have Microsoft Works and can maybe figure a solution here?
My knowledge of D-functions in Excel isn't wonderful. Anyone help out here?
http://www.excelforum.com/excel-form...el-2010-a.html
Regards
Here the OP created a UDF to get the values from website but it's working fine individually but when it is applied to bunch of cells then it's showing 0 for some of the cells.
http://www.excelforum.com/excel-prog...-result-b.html
I don't have any knowledge in getting the data from website but the OP is waiting for some sort of help or direction....
I'm no longer certain of the OP's requirements...thought I had a workable solution...please help if you can...
http://www.excelforum.com/excel-prog...-vba-code.html
I thought this was going to be a relatively simple lookup type problem http://www.excelforum.com/excel-prog...-wildcard.html It has quickly gone beyond my skill level, as I am only good for simple lookups. It almost feels like he wants an lookup function with real search engine "smarts."
Search string -- The Drowsy Chaperone. Find cell containing "Drowsy Chaperone" (without the "the")
Search string -- NC symphony disney. Find cell containing "NC symphony plays Disney songs".
Search string -- Wierd Al Yankovich. Find cell containing Wierd Al (without the Yankovich).
He may not be back until Monday.
I can calculate this with rations but then things add up to more than 100. :-/
http://www.excelforum.com/excel-form...pplicable.html
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Can any1 chime in here and help please? Im having a hard time figuring what the OP wants with what they give...
http://www.excelforum.com/excel-form...29#post3382329
Can someone have a look at this Unable to run code in between "Unprotect" and "Protect" object?
We've maybe made a little progress here http://www.excelforum.com/excel-prog...-wildcard.html but there's no way (in formula form or in VBA) that I am going to be able to manipulate his search strings. Anyone have any new thoughts based on our progress so far?
OP is developing a code with "scripting.dictionary" in which I don't have any expertisation, anyone please help the OP
http://www.excelforum.com/excel-prog...-and-date.html
Anybody have something they can add to this!
Seems to be a formula challenge
http://www.excelforum.com/excel-form...html?p=3388765
Anyone please take care of this thread because the suggestion which I had given makes no sense and I am running out of time too...
http://www.excelforum.com/excel-form...a-are-met.html
OP is trying to copy paste certain data content from excel/word to excel sheet but it is pasting as Picture, Any suggestions???
http://www.excelforum.com/excel-gene...html?p=3392641
This is out of my wheel house. I think it will require VBA beyond my capabilities.
http://www.excelforum.com/excel-prog...s-entered.html
I suggested a formula in this thread
That seemed to satisfy the requirement but now the asker has come back with a twist which I would suggest needs VBA, not my thing......
Could someone please have a look here http://www.excelforum.com/excel-prog...orksheet.html?
Please can someone have a look at this and follow through:
Conditional Formatting
Although I have asked for, and been given, clarification of the requirements, I am still none the wiser.
But I'm not ducking out on because of pure laziness, it is somewhat earthy laziness; I am going away tomorrow for a week. I have a taxi picking me up at around 06:30 to take me to the airport and, from there, to the Greek Islands ... hence I simply do not have time to run with this.
I'd be grateful for any input and, ideally, a resolution.
Thank you all
Regards, TMS
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
I was getting impressed in the way the OP has used the Pictures in Comment and It's a new method to me
Now the OP's expectation is to show the pictures of student along with the names in the DV list. But we are aware it's not at all possible in DV List and the OP's is looking for any alternative method to achieve this... I am not sure whether it can be achieve with the help of any form/activeX combo/list box... So requesting all your suggestion on this...
http://www.excelforum.com/excel-gene...ge-appear.html
In the below thread refer Post # 20 and 21 alone... In the attached file in Post #20 the OP is using the normaly array formula in sales view sheet in Col-D with nested IF's...
But the problem is the below normal array formula is getting failed when it's APPLIED TO HUGE SET OF TABLE DATA.
But I am surprised it's showing result when the table data is 150 rows (appx) of data
INDEX(Table3,SMALL(IF(Table3[Column2]=$C$6,ROW(Table3[Column2])-ROW($D$2)+1),ROW($D1)),MATCH(D$1,Table3[#Headers],0))
http://www.excelforum.com/excel-form...html?p=3414491
Or
Am I missing anything? Please correct me if I have mis-interpreted anything wrongly... Any help/suggestion will be very much useful to the OP and to me as well
Last edited by :) Sixthsense :); 09-21-2013 at 02:44 AM.
I have not a clue how to help this fellow:
http://www.excelforum.com/excel-form...-workbook.html
@Alan: untested but answered ... in theory, it should provide a solution.
http://www.excelforum.com/showthread...=1#post3414705
Regards, TMS
I thought I knew where I was going, but then I ran into using a dynmic range against column letters that extend beyond Z.
I'm clueless how to generate AA and onwards using INDIRECT. Or maybe my whole solution is garbage.
https://www.excelforum.com/showthread.php?t=956986
@daffodil11 : unfortunately, that thread is being blocked by Chrome. If you still have access and can repost the sample workbook, I'll have a look at it
TMS
Don't worry about it!
Jonmo and JBeaucaire jumped right on it and summarily destroyed it. And I totally learned how to use OFFSET to build dynamic ranges instead of INDIRECT.
Last edited by JBeaucaire; 09-23-2013 at 11:37 PM.
Any takers on this issue. I really don't understand this problem.
http://www.excelforum.com/excel-prog...-of-excel.html
An Excel2013 question. This poster has a sheet that fits on the page but wants to see the print preview as a whole page on the screen. Where on 2013 is the zoom on print preview.
He has included a word document which has some screen shots of the view.
http://www.excelforum.com/excel-gene...html?p=3416787
click on the * Add Reputation if this was useful or entertaining.
Thank you JosephP and MartinWilson
if there's anyone here who is willing to download a file at the moment and knows anything about the animatewindow api please add your thoughts here: http://www.excelforum.com/showthread...78#post3417878
thank you :-)
Josie
if at first you don't succeed try doing it the way your wife told you to
http://www.excelforum.com/excel-gene...ze-solver.html
Any of you guys that are good at calling Solver from within VBA (and maybe in a calculation event procedure) want to help this guy out. He doesn't seem interested in solving the problem algebraically.
I am sure this will call for a sumproduct formula of some kind. I just don't know which one. I haven't done very much in that area and would appreciate a helping hand for this OP
http://www.excelforum.com/excel-form...tain-days.html
@Alan
Maybe this:
Formula:
Please Login or Register to view this content.
Regards, TMS
Thanks Trevor, I was close, but couldn't figure out the double negatives. Placed them in a couple of spots to no avail. Thank you.
You can, if you prefer, remove the commas and make the double negatives into asterisks. Should have the same outcome.
Cheers
Biting off more than I could chew.
Should be a nice arrayformula for anyone with a bit more experience than I.
http://www.excelforum.com/excel-form...ricky-one.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.
Any takers here: http://www.excelforum.com/excel-prog...tick-data.html
Anyone wanna take a stab at this one:
http://www.excelforum.com/excel-form...ecutively.html
I don't understand what they want to do.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
This one has been solved but I still don't understand it!
This person is getting an xlb file being loaded but does not why or when. xlb question
I think you meant a file in xlsb file format.I don't know what is this all about?
'Oct3-REVISE.xlsb'!disableButtonsFunctionality
This is an Excel file created in Excel 2007 or later in a binary file format, hence the "b" in file extension.
An *xlb file is an Excel file that stores settings for your menus and toolbars. It's typically named for the version of Excel that it was created in:
Excel15.xlb = the xlb file created in Excel 2013
The OP here is having trouble with permissions to download attachments. Does anyone have a suggestion as to the problem?
http://www.excelforum.com/excel-form...ml#post3430845
Thanks
DBY
Tech team working on this. Update coming soon.
@arlu
Thanks for looking into this.
DBY
http://www.excelforum.com/excel-prog...-criteria.html
Ran into a problem on this one in applying conditional formats by VBA if they are an array formula. I came up with a sendkeys workaround but if anyone feels like trying a proper fix I'd be interested in how to do this. I tried different formula types with no success. Alternatively a non-array formula for the conditional format would probably work as well.
anyone know how to use a formula to add a picture?
http://www.excelforum.com/excel-gene...o-a-value.html
Anyone please take care of this OP's issue, since I am running out of time.
The OP is trying to display a customized message when the Source of the Pivot Table is Missing.
http://www.excelforum.com/excel-prog...refreshed.html
Don't know if this was solved but rather than using MIN(If type array formulas like here
=AND(C2="L",A2<>"A",D2=MIN(IF($C$2:$C$20="L",IF($A$2:$A$20=A2,$D$2:$D$20))))
You can use a COUNTIFS function to ensure that no rows with required criteria have lower values, i.e.
=AND(C2="L",A2<>"A",COUNTIFS($C$2:$C$20"L",$A$2:$A$20,A2,$D$2:$D$20,"<"&D2)=0)
In Excel 2003 you could use SUMPRODUCT in place of COUNTIFS
@DLL:
Formula:Please Login or Register to view this content.
doesn't quite look right. Should it be:
Formula:Please Login or Register to view this content.
Regards, TMS
Yes, thanks TMS
I "fat fingered" a comma out......
In this thread OP is trying to Add Date Picker in Excel 2010 as we are aware by default the Date Picker is not available in 2007/2010 so MS provided a CAB file which will add it in excel root directory.
But OP is using Windows-8 and I don’t know is there any separate CAB file for W-8 since I am running in W-XP.
Anyone please assist the OP for fixing this issue…
http://www.excelforum.com/excel-gene...ml#post3438361
I have not worked much with named ranges - can someone please pitch in here - it would surely be a quick fix which i am not able to do at this point - thx much -
http://www.excelforum.com/excel-prog...ml#post3439804
Hi all,
Not so much an OP struggling for help, more me wanting to know if what the OP says is true (which I've never heard before)! The reason I've raised it here is that, if it could be clarified either way in the post by someone in the know, then that could avoid any potential misinformation on array formulas to other interested readers:
http://www.excelforum.com/excel-form...ategories.html
Thanks a lot
I don't have a solution for this OP. It has to do with a fuzzy Vlookup. Perhaps you can envision a solution
http://www.excelforum.com/excel-prog...ml#post3440964
In the below thread OP attached a workbook which consist lot of drawing objects but when we try to open the workbook then a error message pop up and asking to repair the file. Of course we have to click yes otherwise its not opening the file.
After clicking Yes its deleting the Drawings from Sheet1 (4) and the below is the error message.
http://www.excelforum.com/excel-gene...ml#post3441314PHP Code:<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error030320_03.xml</logFileName>
<summary>Errors were detected in file 'D:Another New TempnewMIFC3 - Copy.xlsx'</summary>
- <repairedRecords summary="Following is a list of repairs:">
<repairedRecord>Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)</repairedRecord>
</repairedRecords>
</recoveryLog>
Any thoughts about how to get rid of this issue?
@Sixthsense: thanks for the feedback and rep.
Having looked at the workbook, I can't help feeling that it is/was an accident waiting to happen. Excel doesn't look to me to be the right tool for this ... although what has been achieved is impressive. Maybe Visio would work better. Love the little images
Regards, TMS
Hm.. His Excel taking more time when moving between sheets and while scrolling too because of many drawings/boxes…
Any how you have given him the most worthy links which will help him further…
Once again thanks for joining in and sharing your valuable suggestions
@Sixthsense: doesn't seem to have worked. I have no idea what else to suggest. As I said, I don't think Excel is the right tool and maybe Excel doesn't think so either
Regards, TMS
@ TMShucks,
No worries since we are trying to offer the best solution whatever we know...
I asked the OP to open it in Open Office and we hope some of the other members will also give some suggestion to the OP to get rid of this issue
OP is asking for Date in Message box to be presented in format 15 October versus US type short date 10/15/2013. I can't seem to get this to work in my VBA solution. Tried using Format(myDate1, "d MMMM") but nothing changes.
Your help, please.
http://www.excelforum.com/excel-prog...-workbook.html
@Alan:
Please Login or Register to view this content.
... worked for me. Don't see why you can't adjust the formatting.
Regards, TMS
Hi all,
OP is wanting a VBA solution to replace his current array-formula set-up as he says he has a very large dataset and things are apparently quite slow.
http://www.excelforum.com/excel-prog...next-cell.html
Cheers
Is this possible thru formulae? The OP needs a formula solution than vba
http://www.excelforum.com/excel-form...ml#post3442808
If it is it'll be extremely awkward, especially if they're wanting to preserve that subtotal set-up.
I just want to suggest this thread to move to "Excel Programming / VBA / Macros" so the OP can get better solution
http://www.excelforum.com/excel-form...ew-column.html
or someone want to help the OP?
Click (*) if you received helpful response.
Regards,
David
Thanks SDCh, done
You're welcome
I'm confused with what the OP want, can somebody help in here?
http://www.excelforum.com/excel-form...-up-value.html
Regards,
SDCh
@ SDCh,
Just one thing I can say...
OP don't have clarity on how to build the data's and the possible methods which exist in excel.
So from my point of view this question will take more followup threads...
Last edited by :) Sixthsense :); 10-19-2013 at 05:39 AM.
Yeah, they haven't exactly made it easy with that set-up. Still, I enjoyed the challenge!
I think so, what i get is, the OP want sum the price on the order list from left to right, but the data are mess with different typo of item list....
I give him another solution, an array formula with list for different typo of item list.
Very, very interesting. I never personally use Tables, and I've only looked at this briefly, but appears to be quite baffling, I have to say. Anyone?
http://www.excelforum.com/excel-gene...ml#post3444116
Can any-one take a look at this and maybe offer any advice to the OP?
http://www.excelforum.com/excel-prog...ml#post3445115
This is beyond a formula-based solution, in my opinion. Might even be tricky with VBA - any experts want to have a go?
http://www.excelforum.com/excel-prog...onant-etc.html
Regards
Done, I think!
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Much appreciated, Olly. And obviously wasn't that difficult at all...for you!
Let's hope the OP's happy with that as well.
Cheers
anyone fancy a CF challenge?
http://www.excelforum.com/excel-gene...ent-cells.html
It's as if Excel can't handle these part no's We were going along famously (I thought) but have come now to a screeching halt!
Update - Jindon has the OP satisfied - but I still wonder how I could have made my code acommodate that data???
Last edited by xladept; 10-22-2013 at 10:17 PM. Reason: typo
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I don’t know what this OP is expecting to do and how and where
http://www.excelforum.com/excel-form...eadsheets.html
Anyone good with counting shifts? Mental block: I can't even think how to approach this.
Track employees which cross shifts and counted one time each shift
Thanks, TMS
Explanation given in the thread, Trevor.
Pete
In the below thread the OP is getting a popup to save the file eventhough the file is saved. After further investigation OP is having lot of class modules which is the root cause of this problem I believe.
I don’t know anything about class module can anyone take care of this thread and help the OP to get rid of this issue?
http://www.excelforum.com/excel-gene...ve-pop-up.html
Some piece of OP’s code…
Please Login or Register to view this content.
Anyone have some aid for this gent?: http://www.excelforum.com/excel-prog...unique-id.html
I am not sure what the OP wants with this, can anyone make sense of it please?
http://www.excelforum.com/excel-form...ml#post3453525
@ FDibbins,
I am just as confused as you are. I find the "20" and "Theoretical value", as clear as mud. Maybe he should employ some helper columns, apply a standard number format, and from there read it into the desired Cell in a Time Stamp Format, using formulae with circular references perhaps. Far too messy, for me to get involved.
Beste Groete, en Mooi Loop!
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
thats it i've reached my limit anyone care to take over here?
http://www.excelforum.com/excel-gene...worksheet.html
Any suggestions on this little "scoring" puzzle.
Got another strange 1. cells contain "something" but appear blank....
http://www.excelforum.com/excel-form...ml#post3454963
Is anyone able to explain why this happens? OP using macro recorder to do a Find--->All.
http://www.excelforum.com/excel-prog...-commands.html
I have lost my way on this 1, anyone else want to take a swing at it?
http://www.excelforum.com/excel-gene...ml#post3459351
In this thread the OP is looking for a simple Sum based on multiple conditions, from my point of view DSUM will be a suitable method and even I tried to help him with Sumifs() too but I can't able to understand what is the exact expected result and how
If anyone interested then please go through the below link...
http://www.excelforum.com/excel-prog...ple-colum.html
OK I have most of this worked out...
http://www.excelforum.com/excel-form...ml#post3459834
The only thing Im having a problem with, is to populate the "Date" column on YTD, there may be anything from 3 to 20 employees per day, and it needs a row per EE
How many different ways can you ask the OP for the basis of a number and continue to get a non-answer??
http://www.excelforum.com/excel-gene...f-numbers.html
You know what they say Alan; there's only so many times you can bang your head against a wall before it stops being fun
But it feels so good when you stop
especially if you are the wall
I've stopped and I feel really good right now.
haha part of the secret is knowing when to stop
vba to stop formatting auto as date from web import
op has problems importing from web 1-9 2-10 etc. as just that without excel changing to dates
i know how to work around manually with a lotus transition formula fiddle but as he has code already is it possible to automate the whole thing?
http://www.excelforum.com/excel-gene...m-the-web.html
Can Anyone think of a way to help this OP?
Anyone please help me with this thread
I tried a lot to help the OP but now I really don’t know what he is trying to do
I given my level best explanation but OP can’t able to Pick it
Here is the link….
http://www.excelforum.com/excel-prog...rm-please.html
Hi all,
OP is requesting some VBA help for this. I've managed to give them a worksheet formula solution of sorts, though they are asking for a more automated set-up.
http://www.excelforum.com/excel-prog...-a-column.html
Thanks in advance to anyone who can pick up on this.
Cheers
my bad,dove straight in as a formula would have done but due to the size of this i think vba would be the way to go any takers?
http://www.excelforum.com/excel-prog...ml#post3466076
Think I worked it out.
It always bugs me when provided examples aren't comparable to the actual application.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Anyone have any ideas on this:
Cells.Find xlDate does not find first date in sheet unless date format is dd/mm/yyyy
Thanks, TMS
In the below thread OP's file is hanging if he press Ctrl+Z or change any cells data. The file seems to be simple .xlsx file so no worry about macro codes. At the same time I suggested the OP to change the calculation to Manual but the OP confirmed that too didn't work
http://www.excelforum.com/excel-gene...l-freezes.html
http://www.excelforum.com/excel-prog...eadsheets.html
User wanted to e-mail me the workbook because he could not upload a workbook. I declined and can't really decipher exactly what the formulas should be without it. Would appreciate if anyone can take over.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks