Call in the Cavalry - 2015

I just want to lift this thread http://www.excelforum.com/excel-gene...-holidays.html

Seems like a well described problem, a bit challenging but not too bad. I'm thinking UDF here, formulas seem impossible.

Got to get to work, can somebody look at this.
http://www.excelforum.com/excel-gene...-textbox3.html

Enter textbox in one sheet and populate textbox in another sheet.

Help Please:

http://www.excelforum.com/excel-form...me-time-2.html

I have no idea why he is having the error he mentions in his last post.

Selecting data using combination, not sure how to do it since it is an iterative process

http://www.excelforum.com/excel-form...-criteria.html

I have no idea what this person wants:
http://www.excelforum.com/excel-form...c-factors.html

Originally Posted by Jacc

I have no idea what this person wants:
http://www.excelforum.com/excel-form...c-factors.html

Me neither...and i want the last 10 mins of my life back :D

I can't tell what this person wants.

They've been bumping for @ 3 weeks.

http://www.excelforum.com/excel-form...ollection.html

This user wants a single cell formula. As you all should know, I'm not fond of single cell megaformulas. If you feel inclined, help him hardcode the lookup table inside of my lookup function (or whatever approach you like for this sort of thing).
http://www.excelforum.com/excel-form...l-formula.html

I think I'm beginning to understand what (s)he wants; but right now, I've lost the will to live...

http://www.excelforum.com/excel-gene...imit-12-a.html

Any takers?

Hi Glenn,

Originally Posted by Glenn Kennedy

I think I'm beginning to understand what (s)he wants; but right now, I've lost the will to live...

.. I know that feeling

Originally Posted by Glenn Kennedy

Any takers?

. I will give it a quick try... looks like the sort of sorting thing I often do.. ( But I will insist on a Before and After sheet. )
Alan

Anybody do this before?
http://www.excelforum.com/excel-prog...o-outlook.html
Send e-mail from excel and get message it was sent

Thank you, Alan!!!

OP is looking for easier way / shorter formula.

I'm out of ideas.

http://www.excelforum.com/excel-form...-weekends.html

Hopefully, one of you will realize what is wanted here.

Originally Posted by xladept

Hopefully, one of you will realize what is wanted here.

I can't...... But
FWIW. I will try.... and get the OP to give a good Before and After, then if I can understand it I will try to answer his request..

Originally Posted by xladept

Hopefully, one of you will realize what is wanted here.

... I not know if this guy real for is, or plant patience from us test to can be &%%§%=(**1§$

http://www.excelforum.com/excel-prog...ml#post4161884

Granted it would be much easier with a sample workbook though!

- Kyle

He did post a sample but, I still don't get it

Hey Doc and Kyle, thanks for looking

Anyone care to visit, or re-visit, this thread: http://www.excelforum.com/excel-prog...ed-varies.html

I can't look at it for a while and I'm out of ideas anyway

Thanks, TMS

This one seems to be mostly a financial question, and I have no experience with Excel's financial functions. The OP does not even seem sure of the underlying equation he should be using (though he does make reference to the ACCRINTM() function). I expect that someone who is not only familiar with Excel's financial functions but financial calculations in general (specifically interest on securities) should be able to make short work of this question.

http://www.excelforum.com/excel-gene...l-formula.html

Any peeps with experience adapting macros for Mac environment, a little help here would be appreciated.

Looks like VBA needed here. Not one for me, then!!

http://www.excelforum.com/excel-gene...-in-excel.html

Another simple macro made difficult because I don't know anything about Macs, if you can assist in tweaking this to save correctly on a Mac system, the OP and I would be ever-so-grateful.
http://www.excelforum.com/excel-prog...directory.html

Anyone with Office 2013 care to take a look at this. http://www.excelforum.com/excel-prog...tpassword.html

Ideally, with 2007 and/or 2010 to make a direct comparison on the same machine.

Regards, TMS

I'm not sure what he is trying to do...and I don't think I'm actually helping...

Sooooooooooo, Guru's, come on down....thanks


//www.excelforum.com/excel-programming-vba-macros/1100914-incorrect-syntax.html

Who is good with formatting and Character.

This one has got me stuck...

http://www.excelforum.com/excel-prog...ml#post4174165

This OP is completely missing my point and I decided to stay away from this thread. So anyone please take care of this thread.

http://www.excelforum.com/excel-form...-dropdown.html

Yes its happening for me too. I typed that content twice to get it podted here.

Originally Posted by Kyle123

…. but the forum's having a paddy so it doesn't show as though I have

…..
.that usually takes a while to show Today…

Originally Posted by :) Sixthsense :)

Yes its happening for me too. I typed that content twice ….

. I replied too. And I too have been having problems all day with the Forum Software doing things like that or not being accessible for a long time
http://www.excelforum.com/suggestion...ml#post4180394
Alan

Anyone who speaks Dutch can help with conditional formatting? http://www.excelforum.com/excel-prog...-datelist.html

Could anybody see if these instructions to hyperlink to a word doc will work for them
http://www.excelforum.com/excel-form...ml#post4201180

I am out of ideas. OP is trying to summarize LARGE and SMALL values across multiple sheets.

In spite of merged cells this part is working.

=LARGE('Season 1:Season 3'!$AF$2:$AH$11,ROWS($1:1))

This is not.

=SMALL('Season 1:Season 3'!$AF$2:$AH$11,ROWS($1:1))

My every attempt to coerce blank cells to FALSE fails. I've tried INDIRECT references to the sheets and only values from the first sheet return.

I'm missing something obvious I'm sure.
Anyone have some ideas?

Edit Left out the link. Sorry.
http://www.excelforum.com/excel-form...e-columns.html

Why did I even try to step in here? The fact that nobody else did should have been a good hint...
Anyhow, I snipped a picture of the button already there and used it as a background for a Modeless Userform, so far so good. Then I started to write code for when this Userform would Show and when it should Hide and realized I shouldn't have. I saw there was some very complex way to capture the scroll event out there on the interweb also

http://www.excelforum.com/excel-gene...scrolling.html

Is this a math problem or is it just a silly circular reference?
http://www.excelforum.com/excel-gene...variables.html

@Jacc:

task 1 is total n. of h - h spent for tasks 2 and 3
task 2 is 20% of task 1 + 15% of task 3
task 3 is total n. of h - h spent for tasks 1 and 2

That is most definitely circular and I don't know how you could make that work.


Regards, TMS

Originally Posted by TMS

@Jacc:

That is most definitely circular and I don't know how you could make that work.


Regards, TMS

Interesting development here:
http://www.excelforum.com/excel-gene...variables.html

Im not even going to try and break that 1 down, CB...

Formula:

=IFERROR(IFERROR(IF(INDEX(OFFSET( 'TWPL Fixtures'!$C$3,(C$2-1)*10,1,10,1),MATCH($B3,OFFSET ('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)) > INDEX(OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,2,10,1), MATCH($B3, OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)), "W", IF(INDEX(OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,1,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)) < INDEX(OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,2,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$C$3,(C$2-1)*10,0,10,1),0)),"L","D")), IF(INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-1,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)) > INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-2,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)), "W", IF(INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-1,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)) < INDEX(OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,-2,10,1), MATCH($B3,OFFSET('TWPL Fixtures'!$F$3,(C$2-1)*10,0,10,1),0)), "L","D"))), "M")

Originally Posted by FDibbins

Im not even going to try and break that 1 down, CB...

Where did that one come from?

Anybody have time for a time formula?
http://www.excelforum.com/excel-gene...ml#post4206938

This thread has me stumped.

I've helped him with all the formulas in the preceeding columns but the lastest one seems a bit tricky.

INDIRECT() plus SUMPRODUCT() plus current year only limitations.

I am not sure what is going on with this one: http://www.excelforum.com/excel-gene...-up-chart.html
Excel does not want to chart the entire data set for the two series that have data, it only charts part of the data.

This one wants to do calculated fields in Pivot table that they can apply slicers to.

I've never done that before and don't have a clue.

http://www.excelforum.com/excel-char...e-average.html

http://www.excelforum.com/excel-gene...rint-area.html

Can someone help this OP - the code looks foreign to me

http://www.excelforum.com/excel-prog...ml#post4200370

@ quekbc

Sorry about that.

Here it is.

http://www.excelforum.com/excel-form...e-columns.html

Originally Posted by quekbc

Now, here's the funny thing. Try creating the formula by typing and selecting the cells using the mouse. I find that I cannot select Season 1 Season 2 and Season 3 sheets at the same time, i.e. it doesn't allow me to do 'Season 1:Season 3'. I don't know why that is the case. Here's the better part, when I create a copy of all the sheets unto a new workbook, it now works - and the SMALL function works too. Another Excel oddity perhaps.

I hadn't tried any of that and yes that is bizarre.

And thanks. I've passed that on.

@quekbc
Thanks for looking into that one.
Good find on the hidden sheets.

Again I'm on deep water. I assume there is a way of restructuring the data and use Pivot Table from multiple sources but I couldn't figure it out. Or is formulas the way to go? I reckon you have free hands to do whatever on this one.
A bit of doubleposting going on as well I guess.

http://www.excelforum.com/excel-form...ncatenate.html
http://www.excelforum.com/excel-gene...e-formula.html

Out of time here. Don't want to leave her hanging

http://www.excelforum.com/excel-form...two-files.html

I hate to call in the big guns on something that should be fairly simple but I cannot figure out what this person wants...
http://www.excelforum.com/excel-form...mn-choice.html
And furthermore, now that I'm at work I cannot see his latest image he attached.
Perhaps someone else can understand what he wants?

This is humiliating. I cannot tell for the life of me why such a simple INDEX / MATCH formula should not work. Have checked for rounding errors etc. An array form of the formula works but not the simple one. Also LOOKUP works, but not HLOOKUP.

http://www.excelforum.com/excel-form...need-help.html

Edit Thanks to everyone who answered the "alarm". This was an education. I thought I was losing my mind.

OP says he is interested in a pivot table/Powerpivot solution: http://www.excelforum.com/excel-form...ml#post4213491 I don't know pivot tables, but suspect that it will be a very effective approach for what he/sheis doing.

My conclusion is that this one may not be possible exactly as the OP envisions it: http://www.excelforum.com/excel-gene...d-in-cell.html If I am wrong, I am hoping someone can step in and help.

As soon as I see:

'Please provide me non VBA or Macros solution.'

I know where it is originating from & I am out.

Does anyone know the idiosyncrasies of advanced filter?

This thread is in dire need.

Hi

Originally Posted by xladept

Does anyone know the idiosyncrasies of advanced filter?

This thread is in dire need.

I am a bit out of my depth here, but had a similar prob.. i think i can get the OP code to work...
Alan
http://www.excelforum.com/excel-prog...ml#post4217202

this one went from a rounding issue to a something to do with the "tooltips" that pop up over chart data points. I have no knowledge of what if anything is changeable in these tooltips. I anyone can contribute anything more to this discussion, it would probably help the OP. http://www.excelforum.com/excel-gene...ml#post4218654

Am I missing something obvious here?

http://www.excelforum.com/excel-prog...and-paste.html

Need someone's help on 2nd and 3rd request here
http://www.excelforum.com/excel-form...ml#post4219798

Anyone care to have a look at this. I suspect that I over-simplified the response and it probably does need VBA. But I'm struggling with wood and trees right now.

http://www.excelforum.com/excel-prog...condition.html


Thanks, TMS

Digital Signatures? Anyone have any experience there that can help this OP.

http://www.excelforum.com/excel-gene...el-2013-a.html

Another one that went from something I thought I knew how to do into the broad unknown of pivot tables: http://www.excelforum.com/excel-char...ace-chart.html I have requested that he/she upload a sample file to see what the source data for the pivot table looks like. If anyone who is good with pivot tables can step in and help us understand how to get the pivot table to summarize the data the way he wants, it would be appreciated.

This looks like a simple VLOOKUP solution, but the Greek character set is causing me fits. Anyone want to try this one?

http://www.excelforum.com/excel-gene...ml#post4222471

I can concatenate multiple results into a cell... I can get an INDEX-MATCH to return unique results, but I'm struggling to do both. I really do have to go and earn some money... Any takers (of the OP's query, not my money!!!)?

http://www.excelforum.com/excel-form...pe-column.html

Am I missing something on what this OP wants?

I think s/he wants cascading updates from a Validation Table, but I just can't understand the question.

http://www.excelforum.com/excel-form...alidation.html

This user is having trouble in Excel 2016. Chart formatting information does not seem to want to save with the file. I cannot recreate the problem in an earlier version of Excel. http://www.excelforum.com/excel-char...ing-stick.html

This is my personal issue
http://www.excelforum.com/excel-form...ml#post4226051
At the moment I get stuck and could not get it around.

Some quick and easy VBA points for someone here, I'm not up to it right now.
http://www.excelforum.com/excel-form...ml#post4224860

@Doc

'manually': Ribbon / View / unhide

VBA: workbooks(3).windows(1).visible=true

@snb
Hi snb
I could not find the manual way. Possibly something lost on the translation to my German Excel, and/ or ( most likely! ) I missed the point.... clicking on a Ribbon I can’t see is puzzling me.
I got to the code line, variations of your suggested, ( I happened to have 4 workbooks open at the time):
Workbooks(4).Windows(1).Visible = True
OR
Workbooks.Item(4).Windows(1).Visible = True

I guess this is telling me that VBA is giving the item number of the Workbook in the order of it being opened. (And in this case I only have one Window open for the Workbook )
Somewhere along the line I think I got close to this, which I find now also works..
WB.Windows(1).Visible = True
( In fact I had in my code ( commented out ) WB.Parent.Windows(1).Visible = True, which i googled,
https://msdn.microsoft.com/de-de/lib.../gg251785.aspx
, but which does not work !?! )

Thanks snb for getting me there on this one
Appreciate it
Alan

Or

workbooks(workbooks.count).windows(1).visible=true

Hi snb

Originally Posted by snb

Or .....

_ ..stimt!! Correct, got it, beides.
Many Thanks for the extra Hinweise.
Alan

P.s.
This looks fun to put at the end of somenones code
ThisWorkbook.Windows(1).Visible = False
Maybe one way to encourage an OP to Feedback

Das freut mich. LG.

Disregard this post

Can anyone offer a suggestion on this 1? I have a feeling it will need VBA
http://www.excelforum.com/excel-gene...ml#post4232883

OP wants to do a date-wise lookback across horizontal records. Each record is 1 row by 4 columns. Wants return to show the complete record match. Managed to do this for a single record match, but OP anticipates multiple returns and wants each field to be concatenated. I can’t even set up formula for this one that enables concatenating UDFs to work.

This looks like a job for VBAman … (or CS?)

http://www.excelforum.com/excel-form...d-on-date.html

Edit You can disregard this one. OP has opted to manually concatenate.

I have this half solved. Need some assistance on the other requirement. Don't have time to spend on working this one out.

http://www.excelforum.com/excel-prog...tock-gaps.html

Just not my day. Here's another one that I started but could not finish.

http://www.excelforum.com/excel-prog...nd-column.html

Serbian English problem

I don't think the basic question is too much of a problem but understanding English is. We have exchanged a few private messages trying to get him/her to start a new thread but to no avail.

http://www.excelforum.com/private.ph...pm&pmid=217683

@tony h

The link you provided appears to be invalid. Link to the Thread please.

Corrected Link below

Originally Posted by tony h

Serbian English problem

I don't think the basic question is too much of a problem but understanding English is. We have exchanged a few private messages trying to get him/her to start a new thread but to no avail.

http://www.excelforum.com/excel-prog...matically.html

Happy New Year...
http://www.excelforum.com/the-water-...ry-2016-a.html

anyone have free time to answer this one
http://www.excelforum.com/excel-prog...g-a-macro.html

posted something but OP much later now my head hurts trying to figure out what the OP is asking for now

http://www.excelforum.com/excel-gene...-in-excel.html

This OP is looking for implentations of "hashing" algorithms in Excel. The internet seems to have several possible solutions. One that we found appears to be VB that would work if the OP knew how to import the stand alone VB class into VBA. He has no VB experience, and I do not have much experience importing a stand alone VB class into VBA. I don't know if there are better solutions out there (I was kind of hoping the OP would be able to perform the internet searches himself) or if there are a few simple steps to importing the code we have found into VBA. If someone wants to look and see if they have anything to contribute, at this point all I can seem to contribute is "here let me google that for you" kind of suggestions.

After taking a second look, I new I didn't read this right.

Any help would be appreciated

http://www.excelforum.com/excel-form...ml#post4248017

I don't see how this can be done by formulae alone. Anyone interested in a VBA challenge?
http://www.excelforum.com/excel-form...ncatenate.html

I have answered the OPs original question (test whether or not a range of numbers is in ascending order) using SUMPRODUCT and an offset range. However, the OP has now let it slip that there can be blank cells. I can't figure it out...

http://www.excelforum.com/excel-form...ncreasing.html

The most complicated IF structure that I have never seen before!

http://www.excelforum.com/excel-form...ml#post4251493

Is there someone willing to jump in?

anyone care to solve this one?
http://www.excelforum.com/excel-gene...-a-filter.html

Somebody want some of this? I've hit a wall with formulas.

http://www.excelforum.com/excel-gene...2-columns.html

http://www.excelforum.com/excel-char...challange.html I don't know how to do "custom tool tips for chart data points". I can google the query for him, though it would probably be faster for him to google it himself. Someone here may have a better suggestion than just "google it".

I doubt this is do-able, but putting it outh there for others to have a go at...
http://www.excelforum.com/excel-new-...-question.html
data is VERY messy

@Ford: maybe post in the 2016 CITC?

we have 1 for 2016?
I was just thinking about making 1, Trevor

edit: just found it lol thanks