Reputation
2,545
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
1 9 18
Newest
 Nice Answer
Impact
~400k people reached

Oct
3
comment How do I install the Sun/Oracle Java SDK on Ubuntu?
@TommasoBarbugli: I've changed my answer to a community wiki. Feel free to edit and complete it if you think this is necessary
Dec
12
comment Pressing down arrow jumps to top of Excel spreadsheet
@Senoculus: you don't have to worry about it. Users with 5k+ reputation can vote to migrate your question (or a mod with a diamond in his/her name can do it right away). Your question might move at a time or another to superuser, this is normal
Nov
28
comment Compare cells based on dropdown
Glad it helped you :). I've posted it as an answer but feel free to edit it or to add your own answer as described here
Nov
26
comment Compare cells based on dropdown
Have a try using INDEX MATCH functions and tell us if you are still stuck
Nov
14
comment Viewing table of contents in Word while editing
@Aiya: thanks. I've edited my answer to reflect your comment
Jul
23
comment excel cells protection
Have a look here: officetooltips.com/excel/tips/… for instance. If it isn't enough, please edit your question to be clearer in your expecations
Jul
23
comment Excel, how to find column number of min value?
nice one (and +1). I've submitted an edit because the English version of Excel uses commas , instead of semi-colons ; to separate arguments within a formula
Jun
21
comment How do I install the Sun/Oracle Java SDK on Ubuntu?
@z7sgѪ: please note that instead of complaining you can edit the answer, it will be peer reviewed and if relevand approved. This way, this (very old) answer will remain up-to-date.
May
28
comment How do I install the Sun/Oracle Java SDK on Ubuntu?
@JayTaylor: are you sure your download worked properly? did you try it all over again? This kind of error is more likely a partial or incorrect download
Apr
23
comment How do I install the Sun/Oracle Java SDK on Ubuntu?
@PawełPrażak: there is no point in downvoting when you didn't find what you expected... yet, I've edited the answer with a seeminlgy working solution for Ubundu 12.04. I cannot test it right here, please tell us if it works or edit the post with a wokring solution.
Apr
3
comment merging duplicates and merge into rows for excel 2007
you could probably build a vba macro to do so. We can help you correcting the code provided you made a first try
Mar
30
comment Turn Excel spreadsheet into a formula
your question is really unclear. We can't understand what you mean, what you intend to do. Show us what the inputs, your expected outputs and so on
Mar
30
comment Block or fade images in Firefox according to their content
you may consider using adblock but it doesn't fit exactly to your needs
Mar
15
comment Count how long a program is used for
I suggest you have a look at this link about time tracking
Mar
14
comment When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?
Your cell needs to be aligned on the left too if you want overflow
Mar
12
comment Create Contact List From Existing Emails
you want to do this while remaining on Gmail? what kind of tool do you intend to use?
Mar
5
comment Excel get cell value which is NOT Match in a row
You're welcome. Sorry, I didn't add that you had to remove the {}
Mar
5
comment Excel get cell value which is NOT Match in a row
It is true that some questions can or could be answered with either formula or VBA. This is sometimes tricky to know wether to post your question. Don't worry, if needed, your question will be migrated.
Mar
5
comment Excel get cell value which is NOT Match in a row
the formula is trying to Match within an array if any of the cell is different from "=NO=" by checking if it returns TRUE
Mar
5
comment Excel get cell value which is NOT Match in a row
sorry. I made my test with only A and B (because "=" is a pain to handle in an Excel cell). Btw, I also corrected because I forgot to translate the TRUE statement.