Ah, Sid, here I am. New kid on the block. No idea how this works. What does this do that I don't have already? Why should I use this? What extra steps do I need to take to be on top of discussions that happen here?
You don't have to install anything... (I remember the last conversation :D)
This is just for the Stack where we can discuss Excel/.Net questions and share important views
you can visit anytime you want
what I have done is enabled the desktop notification on the right so that i get an alert when someone posts here. You may or may not opt for that.
Only approved members (MVP) can chat here. So that the discussions don't go haywire :)
I don't think that in the beginning there will be that many discussions here but later on as more MVPs join, I am sure there will be lot of important discussions happening...
OK, I happened to keep this tab open. I only saw your reply when I came back. There was no email or other notification. This will not work for me. I cannot have yet another tab open for direct messaging. Too many communication systems. If you want me, email me.
I am struggeling with a good solution for the following problem:
As you can see I have a table with evaluation criterias on the one side and I have a score on the other side. So, IF the score is between a certain value then a symbol(like --,-,+/-,+ or ++) should be take.
Atm my "best" solutio...
Definitely something that can change the tome of a statement. I've gone back on at least a few occasions to add one when reading mt own comments and realizing that they could be misconstrued.
named ranges an INDEX might do it but would subscrive a UDF.
Looking at it again, I would completely discard the *End* numbers in favor of a forward LOOKUP on numbers sorted ascending int the *Start* column. An IFERROR function will provide the means to access the value from column B. No mention of structured tables so all cell referenced you be literal. Let me see what I can come up with once I get the data transcribed.
At the risk of exhibiting or exercising hubris, this is SuperUser stuff. My ego usually tells me to comment an answer but my morales tell me to VTC, Off-Topic-Belongs on another site. I am constantly reviewing META threads on the subject to see where the current philosophy stands. Other users (as I've mentioned) contribute to the decision I make.
Questions asking for code must demonstrate a minimal understanding of the problem being solved. Include attempted solutions, why they didn't work, and the expected results. See also: Stack Overflow question checklist
A small request i.e if it's possible to incorporate.
Can the above bold li...
So an IF would have to account for >100 and less than 0. Not really an issue for anyone that has *a minimum of understanding*. I came over to SO for this very reason. I too tired of users that wanted 'turn-key' formulas shoved at them. I often show 'half-an-answer' in order to demonstrate a method or principle that should be understood before proceeding (and asking for more 'turn-key' solutions that they do not understand). If you teach a man to fish you feed him for the rest of his life. Give a man a fish and you feed him for the day.
I don't have a problem with someone asking to resolve a multiple column criteria or a fragmented cell range through worksheet formulas. As a matter of fact, I believe that the [tag;Excel] wiki should be specifically expanded to include complex formulas. I've even written some possible edits on that. The problem I have is the on-hit-wonders hat want everything delivered on a platter because they think they authored a 'good question' without any of the programming effort that this site requests, nee requires.
My earlier blog post on how to write a good question is pretty long, and I suspect that even when I refer people to it, often they don't bother reading it. So here's a short list of questions to check after you've written a question (and to think about before you write the question):
Have you d...
This is just for the Stack where we can discuss Excel/.Net questions and share important views you can visit anytime you want what I have done is enabled the desktop notification on the right so that i get an alert when someone posts here. You may or may not opt for that. Only approved members (MVP) can chat here. So that the discussions don't go haywire :) I don't think that in the beginning there will be that many discussions here but later on as more MVPs join, I am sure there will be lot of important discussions happening...
Objective of this Room: This is a Private room only for MVPs. In this room, MVPs can discuss importants post in Stack.. Be it Excel, .Net or any other technology. I don't think that in the beginning there will be that many discussions here but later on as more MVPs join, I am sure there will be lot of important discussions happening. Also here we can draw attention to specific threads which needs a different pair of eyes ;)
3
Rory: Can you star my above comment so that it shows on the right panel. I can't star my own comment
Right then. I think I need a few moments to become familiar with rooms. I haven't really used them before and the user interface is not very intuitive. Is there a "how to" anywhere?
If I enable desktop notification, what does that actually do? Something on my Windows desktop? Or send an email?
I am struggeling with a good solution for the following problem:
As you can see I have a table with evaluation criterias on the one side and I have a score on the other side. So, IF the score is between a certain value then a symbol(like --,-,+/-,+ or ++) should be take.
Atm my "best" solutio...
Questions asking for code must demonstrate a minimal understanding of the problem being solved. Include attempted solutions, why they didn't work, and the expected results. See also: Stack Overflow question checklist
A small request i.e if it's possible to incorporate.
Can the above bold li...
