Reputation
530
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
4 17
Newest
 Curious
Impact
~59k people reached

Jul
31
awarded  Popular Question
Jul
30
comment sum sign in number cells
Btw, what I just noticed is that when you pull down results, and you haven't locked the cells (with "$"), the cells change in the formula you used when defining a name. So you might just want to drag your "results" cell to the right and that might calculate the B column too with having to make another formula.
Jul
30
comment sum sign in number cells
As far as I know, you can't pass parameters along with a names field. Calling "result" is just calling a name, so I don't think that will work.
Jul
30
answered sum sign in number cells
Jul
30
comment sum sign in number cells
That's because a "=" is needed in front of it to calculate the cells, but that would mean that you lose you "1+2+3" syntax and that it would show "6" instead. Is it required that "1+2+3" stays visible in A1?
Jul
30
comment sum sign in number cells
I guess those cell input are formatted as text?
Jun
19
comment in Excel Range copy, How can I copy without changing the active sheet
Do you mean worksheets instead of tabs?
May
7
comment How can I use multiple IF functions in Excel 2010?
Nesting is what you need here! you cannot have multiple formula's in a cell unless you nest.
Apr
29
answered Cant disable javascript with IE developer tools
Apr
23
comment My outlook 2010 ribbon does not have the vote buttons how do I get the vote commands to show
There seems to be an issue with Sharepoint too if that's been used to send the mail.
Apr
23
comment My outlook 2010 ribbon does not have the vote buttons how do I get the vote commands to show
@Alphonse: have you checked option 1? Do you see that text in the overview page in the outlook client (that check is to see whether they actually send you a vote email)?
Apr
23
answered My outlook 2010 ribbon does not have the vote buttons how do I get the vote commands to show
Apr
19
comment Randomize table guests in Excel
how many guests can a person have?
Apr
10
comment How can I sort a list of numbers, by its last 3 digits in Excel
basically, VBA can solve your problem without having to add additional columns/data to your sheet.
Apr
10
comment How can I sort a list of numbers, by its last 3 digits in Excel
Is VBA out of the question?
Feb
20
awarded  Popular Question
Sep
11
comment Paste a range into a filtered table
Yes, I've created a simplified copy to test it and to use it on here. Those 5 values represent the data we have to copy from the other sheet (so in fact thousand of numbers compared to the 5 here).
Sep
11
comment Paste a range into a filtered table
No, we have thousands of numbers from another sheet that we want to past in an existing table that's filtered. It's gonna be a one time paste, but doing this manually will take a long time.
Sep
11
comment Paste a range into a filtered table
@DaveRook: should be clearer
Sep
11
revised Paste a range into a filtered table
added 26 characters in body